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 |
|
namishtiwari
Starting Member
11 Posts |
 Posted - 2008-11-24 : 02:38:21
|
| Hi, |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-11-24 : 02:40:36
|
| Are there large number of other indexes existing on table?Does inserts happens to the table frequently and in bulk? |
 |
|
|
namishtiwari
Starting Member
11 Posts |
Posted - 2008-11-24 : 03:16:11
|
| Thanks for your quick response.No there are no indexes and insert do happen quite frequently with bulk data.Thanks NT |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-11-24 : 03:25:07
|
quote:
Originally posted by namishtiwari
Thanks for your quick response.No there are no indexes and insert do happen quite frequently with bulk data.Thanks NT
then please keep in mind that addition of extra indexes will make inserts slow.Add it only if you're sure that you frequent query using the concerned column. Also consider dropping and recreating index if you want to make bulk inserts faster (which again depends on frequency at which insertions happen)In future, please ensure you post only in relevant forums.This is script library used for posting working scripts. you should be posting this in 2005 or 2000 forums. |
|
|
|
namishtiwari
Starting Member
11 Posts |
Posted - 2008-11-24 : 03:29:30
|
| Thanks for your valuable comments.from next time i will post in the section relevant to this.ThanksNT |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2008-11-25 : 04:21:44
|
| moved from script library.___________________________________________________________________________Causing trouble since 1980Blog: http://weblogs.sqlteam.com/mladenpSpeed up SSMS development: www.ssmstoolspack.com <- version 1.1 out! |
|
|
|
|
|
|
Index creation