am 31.07.2006, um 15:55:39 +0100 mailte Richard Huxton folgendes:
> Christian Rengstl wrote:
> >My version is 8.1.4. Here is the plan for the query, it's performed on a
> > Total runtime: 1903.894 ms
> >And yes i have indexes on both pid (varchar(15)) and crit(varchar(13)).
>
> That's not quite what Andreas asked. Do you have an index on (pid, crit)?
He has 8.1, and i think, we have bitmap index scan for such tasks...
(we don't need a index over both columns)
Andreas
--
Andreas Kretschmer (Kontakt: siehe Header)
Heynitz: 035242/47215, D1: 0160/7141639
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net
=== Schollglas Unternehmensgruppe ===