We use SQL Server 2000. Inorder to increase the performance archived about
2.5 million records.

However after the archival, the performance is found to be reduced as you
can see in the below comparison details. This downsizing of almost 2.5
millions records has been followed by an "update statistics" in all table
from where, records were removed.



Please advise what are the other tuning options we need to explore?






After                                     Before


Archival                                Archival

- To reset working status for a plant                              57s
40s
- To get the menu of pre-release:
delay before having possibility to chose
plant and report for pre release                                    2 min 4s
2min 41s
- To select a plant                                                     2
min 12s 2min 5s
- To pre-release the P&L2 of a plant                            4 min 4s
5min 22s




Thnaks and Regards

Sathian

Trying to match lowercase
too long...
datetime between problem
SQL Join question - getting most recent value in a history table
Select problem Msg. 156