Does the order in which I put my conditions in a where clause have any effect on the processing time of an SQL Query?
Example...
as apposed to...
Will putting the LIKE statement behind my general equality statements speed it up?
Example...
Code:
select hord, chbcon, hcust, hcpo from bpcsffg/ech where chbcon like upper('%hospital%') and hcpo = '8' and hcust = 9520 order by hord
Code:
select hord, chbcon, hcust, hcpo from bpcsffg/ech where hcpo = '8' and hcust = 9520 and chbcon like upper('%hospital%') order by hord
Comment