[dba-SQLServer] Large cover index slows things down

That's beautiful (index-creation time). Be aware, however, that the maximum
number of indexes on a single table is 249 (LOL).

Since you have so much on your plate, and I so little, perhaps you might
consider farming something my way. :)

Oh, incidentally, I am looking for copies of the following software:

Adobe PhotoShop
Adobe Illustrator
Adobe FrameMaker
Adobe Acrobat (full -- last version I have is 6.0)

Given so much on your plate, I doubt that you have time for such unrelated
activities, but I thought I'd inquire anyway.

A.0

On 1/4/08, jwcolby <jwcolby at colbyconsulting.com> wrote:
>
> Arthur,
>
> I knew these existed but have never used them.  Given everything on my
> plate
> and my current state of knowledge or lack thereof, I might just delete the
> larger cover indexes back out.  the use of the single field cover indexes
> has worked wonders on my processing times already.  The client tends to
> ask
> for the same select fields over and over.  in this case I had to add 8 new
> indexes but had three in place already.  Luckily the creation of the cover
> indexes only takes 2 minutes or so per.  Over time I will end up with
> every
> field already indexed and the process of filling an order will get less
> time
> consuming.
>
>
> John W. Colby
> Colby Consulting
> www.ColbyConsulting.com
>