Hi, I tried using LIKE instead of = on a varchar column and found the results astonishingly quick?
select * from table where columnname LIKE 'abcd' is far quicker than select * from table where columnname = 'abcd' Is this true? Thanks
Hi, I tried using LIKE instead of = on a varchar column and found the results astonishingly quick?
select * from table where columnname LIKE 'abcd' is far quicker than select * from table where columnname = 'abcd' Is this true? Thanks