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 -> Re: Avoiding table or index access at all

Re: Avoiding table or index access at all

From: Matt <matt.selph_at_gmail.com>
Date: 25 May 2005 11:20:57 -0700
Message-ID: <1117045257.444457.282550@g14g2000cwa.googlegroups.com>


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

Original text of this message

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