Ühel kenal päeval, R, 2006-07-21 kell 08:29, kirjutas Jim C. Nasby:
> No, this is 8.1.3, and it's a production machine so I'd prefer not to go
> about dropping indexes to get cost comparisons; unless there's some way
> to disable the use of an index in a given backend?
Currently the closest thing is
BEGIN;
DROP INDEX xxx;
test query here
ABORT;
> Otherwise I'll try
> and come up with a test case.
--
----------------
Hannu Krosing
Database Architect
Skype Technologies OÜ
Akadeemia tee 21 F, Tallinn, 12618, Estonia
Skype me: callto:hkrosing
Get Skype for free: http://www.skype.com