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-24 : 06:33:15
|
| i do BCP on two staging tables . actualy i need to store data in 1500 columns , so i splitted this two table to store 1030 + rest ...to make synch have to chk these two tables and do update by joining 3 columns . there is no index on this two tables .. this updation happening for 1.40 min .. i created non cluster index on this table for that 3 columns .. but still it takes 1.25 min .. 15 minutes is not much improvement ... atleast it shud run in 30 min .. that is actual improvement ... there is no complicated qry .. just joining 2 tables with 3 columns .. but data is 3.5 lak. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-05-24 : 07:32:09
|
| Have you had a look at execution plan for the UPDATE query? That should give you an idea of whether query engine is using those indexes and also what step is costly step involved. |
 |
|
|
niranjankumark
Posting Yak Master
164 Posts |
Posted - 2008-05-24 : 07:40:07
|
| one table uses index scan ( cost 15 %) and another one is index seek ( cost 85%) ..do u need showplan text ???? |
|
|
|
|
|
|
Non cluster on staging table