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 - 2008-05-20 : 02:08:36
|
| BCP done initially in staging tables ( 2 ( 1000 columns)) which does have any index . by using this table records will be populated to main table . in this scenario this staging table uses join with main table for updation. so main table column has index ( non cluster or cluster ) but this staging table does not have. cud i add non cluster index on this staging ??? if i add will it affect BCP ???this process runs 6.30 minutes ( bcp takes only 10 minutes for 3.5 lak records) . and staging table used in 75% of joins |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-05-20 : 02:22:56
|
| Yup you can add a non clustered index provide you're mostly using that column on joins. |
 |
|
|
niranjankumark
Posting Yak Master
164 Posts |
Posted - 2008-05-20 : 03:04:32
|
| yes i have used in joins .. however by doing bulk insert and deletion will it make any impact ???noncluster will not affect like cluster while insertion and deletion am i correct ?? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-05-20 : 09:26:39
|
quote:
Originally posted by niranjankumark
yes i have used in joins .. however by doing bulk insert and deletion will it make any impact ???noncluster will not affect like cluster while insertion and deletion am i correct ??
But it will still need to update the index table with info of newly inserted/deleted records. |
|
|
|
|
|
|
Performance issue