Re: Access and Filter

FILTER is applied to each entry examined

ACCESS (for indexes) identifies the columns used

    for the start and stop positions in the index range     scans.

Consequently you can get FILTER predicates on index lines if your query involves only partial use of a multi-column index. e.g.

    col1 = 'xxx'
-- and col2 in index not referenced
and col3 = 'yyy'

-- 
Regards

Jonathan Lewis
http://jonathanlewis.wordpress.com

Author: Cost Based Oracle: Fundamentals
http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html

The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html


"klabu" <noone_at_gmail_dot_com> wrote in message 
news:12kogcnfeebri21_at_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>

>