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 |
|
boreddy
Posting Yak Master
172 Posts |
 Posted - 2009-09-25 : 04:58:02
|
| I have two table one table contain 15 lacks records, another table contain 90 recordsthe small table having the many references to big table columns When i tried to join both these table any try to up date the records in the main table it is taking more than 14 min but nearly one month back i did same operation here, on that time it took 3 min only Why it is taking more time here Please give suggestion |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-09-25 : 13:16:00
|
| what are indexes available on tables? have you had a look at execution plan for update? |
 |
|
|
|
|
|
Updation taking lot of time