ws and
bottom one 20 rows.
The weird thing is, why is explain showing such a high cost for going
through the indices?
Both tables have been vacuumed(both normal and with analyze), so the
optimizer has completely up-to-date stats.
Thanks,
Ole Gjerde
Query with problem:
SELECT
Hi,
I'm still having this same problem.
Below is a simple test to show the problem.
Same table as before, but I removed all indices except the itemid
field(serial).
Thanks,
Ole Gjerde
parts=> create index av_parts_nsn_index on av_parts(nsn);
CREATE
parts=> explain select * from av_
vacuum on the table.
The index on partnumber, itemid and vendorid is being used properly, all
others are not.
Can someone explain this?
Thanks,
Ole Gjerde
