fetch rows fastly

Without indexing, How to fetch rows fastly from a table ?

What is the problem if you go for indexing.

another option using constraints (primary key or unique)

Fetching rows fastly can be done using indexes can only be done, if you use indexing for one column there is not at all a problem of accessing the data faster.
if u use more than 1 column on indexing, it might be problem
thanks

[QUOTE=susarlasireesha;20413]Without indexing, How to fetch rows fastly from a table ?[/QUOTE]

Dear susarlasireesha,

Try query optimizer HINTS.
You can choose between Default, /*+ CHOOSE */, /*+ RULE */, and /*+ FIRST_ROWS */.

I hope this will help you solving your query.

Have a pleasant time.

if we define a unique or primary key on a column in a table automatically a unique index will be created.No need to define manually.