You are viewing a single comment's thread. Return to all comments →
What? No. In MSSQL, using
LIKE '[aeiou]%'
will allow the query optimizer to take advantage of any indexes on the City column, while using SUBSTRING will prevent it.
Seems like cookies are disabled on this browser, please enable them to open this website
Weather Observation Station 6
You are viewing a single comment's thread. Return to all comments →
What? No. In MSSQL, using
will allow the query optimizer to take advantage of any indexes on the City column, while using SUBSTRING will prevent it.