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 |
|
niranjankumark
Posting Yak Master
164 Posts |
 Posted - 2007-11-17 : 04:50:11
|
| Hi i have table AUTO.Every week this will get inserted and deleted the records(3 lakhs).After insertion i need to update(takes 25 minutes) based on requirement on this table. iN where condition i use only two columns.For that columns can i created nonclustered index??? bulk insert and deleting will take moretime if add this index ???If i add Non cluster will it improve performance ? |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2007-11-17 : 12:57:15
|
| How unique are those two columns? Adding non clustered index can help but it can slow down the bulk inserts. Its a tradeoff and you have to make the call. I assume your bulk inerts happen during off hours? if so then you can trade off a slight performane for faster queries during the day for your users.Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
 |
|
|
monty
Posting Yak Master
130 Posts |
Posted - 2007-11-25 : 22:06:15
|
| why no create indexes after the insertions which can speed up the whole process... here is an article which wud be quite helpful for u http://www.mssqltips.com/tip.asp?tip=1378its me monty |
|
|
|
|
|
|
Nonclustered - Index