Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-05-15 : 09:21:28
|
Rajasekhar writes "Dear Sir,
We have a Problem on SQL Server clustered index.
We have a table with 70 million records. Which has clustered index on one of the fields. Every day we will be deleting 2 to 3 million records and Inserting 5 million records into this table.
Since we have clustewred index on this table it is taking lot of time to run these queries. and some times it is getting time out error. We just can't keep the time out option open because this is a valuable database and most of the people will be accessing the table to run their queries from the front end(their PCs).
Since it has clustered index upon running such queries which will deal with large amount of data, SQl Server must be rewriting the entire table. So even to insert 0.9 million records it is taking some thing like 30 min. time, but, we cannot afford to loose that much time in updating table.
We definitely need clustered index to run the customers queries as fast as possible. At the same time we need to update the table as explained at the top.
Please peovide me some solution for this peoblem. I will be waiting for your Answer.
Regards
Rajasekhar" |
|
|
|
|
|
Problems with Clustered index on SQL Server