Hi Scott,
Am 07.06.2008 um 16:53 schrieb Scott Marlowe:
I'm experimenting with different indexes to speed up my queries and
I was
wondering if it is possible to temporarily deactivate an index, so
it won't
be considered in the evaluation of query plans. The reason is that
dropping
and then rebuilding an index takes up time which I would rather not
wait.
I couldn't find a command to do that, but I'm guessing that it
should be
possible by manipulating a structure in the catalog?
Try this:
begin;
drop indexname;
explain analyze select ...;
rollback;
That works, but I'm still looking for another way to deactivate the
index. The reason being, that my query load is randomly generated by
a Java program and I don't want to go and change the SQL compiler.
Cheers,
Viktor
