> Yeah, a scan over just the index itself would be a perfect way to ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ I believe that Oracle updates index statistic on-fly... Meta-page is always in cache for inserts, so there will be no additional reads. > gather stats. The normal objection to it (can't tell whether entries > correspond to currently-valid tuples) doesn't apply, because we don't > really care whether the stats are perfectly accurate. Vadim
- Re: [SQL] Use of index in 7.0 vs 6.5 Tom Lane
- Re: [SQL] Use of index in 7.0 vs 6.5 Ryan Bradetich
- Re: [SQL] Use of index in 7.0 vs 6.5 Jeff Hoffmann
- Re: [SQL] Use of index in 7.0 vs 6.5 Tom Lane
- RE: [SQL] Use of index in 7.0 vs 6.5 Mikheev, Vadim
- Re: [SQL] Use of index in 7.0 vs 6.5 Bruce Momjian
- Re: [SQL] Use of index in 7.0 vs 6.5 Tom Lane
- Re: [SQL] Use of index in 7.0 vs 6.5 Bruce Momjian
- RE: [SQL] Use of index in 7.0 vs 6.5 Hiroshi Inoue
- RE: [SQL] Use of index in 7.0 vs 6.5 Mikheev, Vadim
- Mikheev, Vadim