On Mon, 29 Oct 2001, Vsevolod Lobko wrote:
> Seems that problem is very simple :))
> MSSql can do queries from indexes, without using actual table at all.
> Postgresql doesn't.
> So mssql avoids sequental scanning of big table, and simply does scan of
> index which is already in needed order and has very much less size.
Hmmm, could anyone imagine a simple or not *solution* of the Problem.
I´m thinking of some switch the database programmer could use if he
really knows what he is doing.
In response to
pgsql-hackers by date
|Next:||From: Dave Page||Date: 2001-10-30 10:02:00|
|Subject: Re: DROP/CREATE|
|Previous:||From: Tille, Andreas||Date: 2001-10-30 09:55:50|
|Subject: Re: Serious performance problem|