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 -> Access and Filter

Access and Filter

From: klabu <noone_at_gmail_dot_com>
Date: Sat, 4 Nov 2006 02:30:30 -0500
Message-ID: <12kogcnfeebri21@corp.supernews.com> 






Predicate Information (identified by operation id):




   2 - access("EMPNO"=7654)



Predicate Information (identified by operation id):




   1 - filter("ENAME"='KING')





What is the diff between "access" and "filter" ?
Just that "access" means INDEX access and "filter" means FT Scan ?



thanks

-- 
<10gR2> 


Received on Sat Nov 04 2006 - 01:30:30 CST












Original text of this message













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