开发者

Elapsed time of SQL

开发者 https://www.devze.com 2023-02-17 20:49 出处:网络
When I remove 41 and 42 lines, Elapsed time is \"00:00:03.13\". The \"com_site开发者_运维技巧\" table aliased as [c] has no index or PK.

Elapsed time of SQL

When I remove 41 and 42 lines, Elapsed time is "00:00:03.13". The "com_site开发者_运维技巧" table aliased as [c] has no index or PK. Result records count is 5503(20 records before removing.) Could anyone explain me why this happens? Thanks...


Even though the alias [c] has no index, the conditions

c.site_gb LIKE 'A%'
c.up_dept_cd='A001'

can be processed first if [c] is small enough compared to the other tables. Processing this first would be preferable to processing the correlated 2-level sub-query involving the tuple (bank_cd, acct_no).

0

精彩评论

暂无评论...
验证码 换一张
取 消