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 |
|
ms.gangadhar
Starting Member
8 Posts |
 Posted - 2012-06-06 : 03:50:16
|
| Dear All,I have tables for audit to a transaction table and these audit tables are filled up so quickly as there is an entry for each transaction to a main tale.Hence i am planning to archive the audit table to a history table which is very similar schema as audit table.Now i want to create an Indexes on Audit table pls kindly suggest.Thanks-Ganga |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
|
|
|
|
|
suggestion to create index on auidt table