avoiding indexes on queries

[krishhhna]

hi,
how can i avoid using indexes on my queries

[debasisdas]

Indexes are created to be used in queries to increase the performance of queries. If u dont want to use ,they why you created all those indexes.

[gintsp]

Indexes are created to be used in queries to increase the performance of queries. If u dont want to use ,they why you created all those indexes.

MM sometimes full scan of a table is better access path than index scan-table scan. Also there are obligatory indexes for Primary/Unique keys and very strongly advised indexes on Foreign keys :)

OK to the OP question is - are you really sure that using indexes is your problem?
Then you can try hint all_rows or the same optimizer_mode. It informs Oracle that you need get back all the data as fast as possible and not only the first row as fast as possible.
Another option is to try FULL or NO_INDEX hints. However I suggest you use hints as a last resort only.
For all hints see Oracle docs:

http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/sql_elements006.htm

Gints Plivna

http://www.gplivna.eu