performance on update using subquery versus correlated update
|
sql server version |
1 |
Microsoft SQL Server 2014 - 12.0.2000.8 (Intel X86)
Feb 20 2014 19:20:46
Copyright (c) Microsoft Corporation
Express Edition on Windows NT 6.3 <X64> (Build 9600: ) (WOW64) (Hypervisor)
|
|
cus_id |
cus_class |
cus_value |
1 |
1 |
A |
Text1 |
2 |
1 |
B |
abc |
3 |
1 |
C |
xyz |
4 |
2 |
A |
Text2 |
5 |
2 |
B |
NULL |
6 |
2 |
C |
NULL |
|
cus_id |
cus_class |
cus_value |
1 |
1 |
A |
Text1 |
2 |
1 |
B |
Text1 |
3 |
1 |
C |
Text1 |
4 |
2 |
A |
Text2 |
5 |
2 |
B |
Text2 |
6 |
2 |
C |
Text2 |
|
λ
.NET NoSQL database for rapid development
|