Re: sys.col_usage$ question
- From: "Jonathan Lewis" <jonathan@xxxxxxxxxxxxxxxxxx>
- To: "Oracle Discussion List" <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 27 Dec 2004 19:19:05 -0000
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';
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
