Re: sys.col_usage$ question

equality_preds 
    colX = 99

equijoin_preds
    t1.colX = t2.coly


The table is used by Oracle in its attempts to
do automatic selection of columns that could
use histograms.  It's on my to-do list to see if
it could be helpful for anything else.  The main
problem with it for analyzing indexing strategies
is that you get no clue about multi-column 
predicates.

    

Regards

Jonathan Lewis

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

http://www.jlcomp.demon.co.uk/seminar.html
Public Appearances - schedule updated Dec 23rd 2004



----- Original Message ----- 
From: "rjamya" <rjamya@xxxxxxxxx>
To: "Oracle Discussion List" <oracle-l@xxxxxxxxxxxxx>
Sent: Monday, December 27, 2004 7:06 PM
Subject: sys.col_usage$ question


Maybe I am being little bit clueless (blame that on Eggnog) but what's
the difference between the columns equality_preds and equijoin_preds
in sys.col_usage$??

Has anyone attempted better indexing methodology based on this table?
We have got a bit of re-engineering going on and came to this table
when analyzing index usage.

TIA
Raj
------------------------------
select standard_disclaimer from company_requirements where category =
'MANDATORY';
--
http://www.freelists.org/webpage/oracle-l


--
http://www.freelists.org/webpage/oracle-l

Other related posts: