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 |
|
rnbguy
Constraint Violating Yak Guru
293 Posts |
 Posted - 2007-02-08 : 23:52:44
|
| we're currently trying to clean up our db, weve come across a table which has 19 million records, this table is used for reports, the reports are random and can one day need items upto two years old from this table and at times items from 2 months ago...the problem is this table is huge and it is taking a while for records to go through it, what is the best solution? |
|
|
MohammedU
Posting Yak Master
145 Posts |
Posted - 2007-02-09 : 01:07:26
|
| Check BOL for topic "Table Partition"If table partition is not an option..19 million is not huge...Make sure you have right indexes... Create a clustered index on Date column... MohammedU |
 |
|
|
rnbguy
Constraint Violating Yak Guru
293 Posts |
Posted - 2007-02-09 : 01:15:02
|
| thanx, it helps alot |
|
|
|
|
|
|
best way to do this?