Run Code  | API  | Code Wall  | Misc  | Feedback  | Login  | Theme  | Privacy  | Patreon 

performance on update using subquery versus correlated update

Language: Layout:
View schema
Execution time: 0,03 sec, rows selected: 13, rows affected: 10, absolute service time: 0,2 sec, absolute service time: 0,2 sec 
edit mode |  history  | discussion
   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