Re: [PERFORM] local selectivity estimation - computing frequency of predicates

2007-04-13 Thread Tom Lane
"Avdhoot Kishore Saple" <[EMAIL PROTECTED]> writes: > How to compute the frequency of predicate (e.g. Salary > $7) in an > SQL query from a DB's pre-defined indexes?". I'm specifically looking at > how to retrieve information about indices (like number of pages at each > level of index, range o

[PERFORM] local selectivity estimation - computing frequency of predicates

2007-04-13 Thread Avdhoot Kishore Saple
Dear All. How to compute the frequency of predicate (e.g. Salary > $7) in an SQL query from a DB's pre-defined indexes?". I'm specifically looking at how to retrieve information about indices (like number of pages at each level of index, range of attribute values etc.) Any suggestions