We are using SQL Server 2005 x86 enterprise edition. We have one table which has 13 crores / 130 million records. When we insert a record in that table it is taking around 30 seconds. Can u please help optimize it.
The table currently has 1 primary key (Clustered Index) and 4 non clustered index.
View Complete Post