“%” 比 “=” 快?
為何第一語句比第二語句慢?
語句一:select * from pr04_pr05_su_jiao_原材料 with (nolock) where pr0501='YMU5008' and pr0408 = '005' order by pr0504,pr0503 )
語句二:select * from pr04_pr05_su_jiao_原材料 with (nolock) where pr0501 like '%YMU5008' and pr0408 = '005' order by pr0504,pr0503