Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Avoiding table or index access at all
In order to bypass a table you'll need to omit the 'FROM' clause.
However, 100% of the time you will receive an ORA-00923: FROM keyword
not found where expected error.
But, other than being a smart ass, if you are talking about a set of data that is accessed frequently enough that the blocks are not aged out of the database buffer cache, Oracle can just grab that data (provided that your query is written exactly the same). Received on Wed May 25 2005 - 13:20:57 CDT