Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Avoiding table or index access at all

Avoiding table or index access at all

From: <nomorekiss_at_gmail.com>
Date: 25 May 2005 07:51:14 -0700
Message-ID: <1117032674.514432.54030@o13g2000cwo.googlegroups.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US