Question on performance using LIKE vs EQUAL w SUBSTR
Hi,
I was wondering if using a LIKE operator is slower than using a "=" operator using substrings?
1) Using LIKE
SELECT * FROM TABLE WHERE NAME LIKE "MAC%";
2) Using '='
SELECT * FROM TABLE WHERE SUBSTR(NAME, 0,3) = 'MAC';