Efficiency difference?# Database - 数据库
s*r
1 楼
Reading some code from other team.
He wrote code in such a way,
case when a='1' then 'N'
when a='2' then 'N'
.....
instead of case when a in ('1','2',....)
No idea whether there is some difference between operation time. Anyone has
idea? Thanks.
He wrote code in such a way,
case when a='1' then 'N'
when a='2' then 'N'
.....
instead of case when a in ('1','2',....)
No idea whether there is some difference between operation time. Anyone has
idea? Thanks.