Re: Serious performance problem

On Wednesday 31 October 2001 03:13, you wrote:
> On Tue, 30 Oct 2001, Alex Pilosov wrote:

> As I said all this wouln´t be a problem for my application. I just
> run a sequential insert of data each night. Then the database is read
> only.
>
> Does anybody see chances that 'index coverage' would be implemented into
> 7.2. This would be a cruxial feature for my application. If it will

Andreas,

I have the feeling that your problem is solved best by taking a different
approach.
As A. Pilosovs posting pointed out, index coverage is a problem intrinsic to
the MVCC implementation (IMHO a small price to pay for a priceless feature).
I can't see why much effort should go into a brute force method to implement
index coverage, if your problem can be solved more elegant in a different way.

With the example you posted, it is essentially only simple statistics you
want to run on tables where the *majority* of records would qualify in your
query.
Why not create an extra "statistics" table which is updated automatically
through triggers in your original table? That way, you will always get
up-to-date INSTANT query results no matter how huge your original table is.

And, don't forget that the only way MS SQL can achieve the better performance
here is through mercilessly hogging ressources. In a complex database
environment with even larger tables, the performance gain in MS SQL would be
minimal (my guess).

Horst