On Sun, Dec 26, 2004 at 13:30:15 +0100,
Karl Vogel <karl(dot)vogel(at)telenet(dot)be> wrote:
> This depends on the version of Oracle you're using. Oracle 9i
> introduced Index Skip Scans:
> I don't know whether pg has something similar?
Postgres doesn't currently do this. There was some discussion about this
not too long ago, but I don't think anyone indicated that they were going to
work on it for 8.1.
Postgres can use the leading part of a multikey index to start a scan,
but it will just do a normal index scan with a filter.
In response to
pgsql-performance by date
|Next:||From: amrit||Date: 2005-01-02 02:54:32|
|Subject: Low Performance for big hospital server ..|
|Previous:||From: Vishal Kashyap @ [SaiHertz]||Date: 2004-12-31 05:48:02|
|Subject: Optimization while compiling|