Re: Antw: Re: Query questions

[Richard Huxton <dev(at)archonet(dot)com>]

A. Kretschmer wrote:
> 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)

Hmm - I'd have assumed an index spanning both columns would be a win 
where the selectivity was reasonable (as it looked here). Reading 
through the original post, I'd be tempted to see if an index on 
(pid,crit,iDate) could be used for the sorting too. If the planner is 
smart enough to spot it, that would presumably be the best result.

--
  Richard Huxton
  Archonet Ltd