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.
Kind regards
Andreas.