Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Avoiding table or index access at all
I want to set a condition in the where clause of the select statement
which eliminates any table (or index) access or atleast minimizes the
time needed to execute statement.
To be more specific:
The query selects from all_objects and I would like it not to return
any rows and not to perform and activity at all.
Is that possible with the where condition or some hint perhaps ?
Please don't ask me about details of what it's for (It's hardcoded in application, but I can add where clause manually). Received on Wed May 25 2005 - 09:51:14 CDT