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 |
|
anup_snwn
Starting Member
6 Posts |
 Posted - 2008-01-18 : 04:35:56
|
| hi friends,i am using update statement with innerjoin with 2 tablesmy first table have 3500000 & second table have 2000 recordsbut it takes more time...i dont know why it happens..any other soluctions for incresing speed of transction |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-01-18 : 05:45:14
|
| do you have proper indexes on fields where you take join? if you want more help please post DDL of tables. |
 |
|
|
anup_snwn
Starting Member
6 Posts |
Posted - 2008-01-18 : 06:01:15
|
| how to create indexes in my query??????? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-01-18 : 09:26:03
|
| I was asking about indexes on tables used in query |
|
|
|
|
|
|
update with innerjoin problem