Posted by othellomy on 03/30/07 10:54

On Mar 30, 12:48 am, "Zamdrist" <zamdr...@gmail.com> wrote:
>
> I did end up archiving off most of the data from the tables in
> question and wrote a custom interface to that using ASP.Net. Works
> like a charm, no indexes whatsoever.

Does that mean who have no io problems if you use ASP.NET?

Archiving and subsequently
> deleting the data from the production tables, and rebuilding existing
> indexes had little to no effect on performance unfortunately.
> Again...up a river with no paddle, lol.

The indexes you have are useless. Therefore, rebuilding them will not
make any difference. You need to identify what columns (preferably
one, at most 2) you need your clustered indexes for. Hopefully the
system will use those indexes.

[Back to original message]