Re: [SQL] 7.3.1 index use / performance

Achilleus Mantzios <achill@matrix.gatewaynet.com> writes:
> About the stats on these 3 columns i get:

Does 7.2 generate the same stats?  (minus the schemaname of course)

Also, I would like to see the results of these queries on both versions,
so that we can see what the planner thinks the index selectivity is:

EXPLAIN ANALYZE select * from noon where
v_code='4500';

EXPLAIN ANALYZE select * from noon where
report_date between '2002-01-07' and '2003-01-07';

            regards, tom lane