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 |
|
Delinda
Constraint Violating Yak Guru
315 Posts |
 Posted - 2008-08-21 : 22:06:04
|
| Hi,Let's say my table structure as follow,tblSalesHistoryTrxNo | InvDate | Customer ---------------------------------0000001 | 1/23/2004 | 3380000002 | 1/23/2004 | 133......0200000 | 1/23/2006 | 449......0400000 | 1/23/2007 | 2200408999 | 1/23/2008 | 330*The data above have 3500000 million row.1. I want to split the data between year such as 2004 into A table, 2005 into B table, 2006 into C table and so on.2. I put clustered index to InvDate before perform the query that will split the data.Did my clustered index to InvDate accurate? Need technical advice |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-08-22 : 00:12:19
|
| Clustered index may speed up query performance but will not affect data accuracy. |
 |
|
|
Delinda
Constraint Violating Yak Guru
315 Posts |
Posted - 2008-08-22 : 00:14:30
|
| hi mister,did my clustered index above will speed up my performance (want to split the data between year such as 2004 into A table, 2005 into B table, 2006 into C table and so on)? |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-08-22 : 09:08:26
|
| Can't you use Table partitioning if you really want it to partition through Year? |
|
|
|
|
|
|
Did my index (Clustered) is accurate?