[AccessD] xyz* faster than *asd

Charlotte Foust charlotte.foust at gmail.com
Sat Jul 9 22:16:17 CDT 2011


Because an ampersand at the front means the entire recordset has to be examined. The ampersand at the back means the records that don't match the initial letters don't need to be examined at all.

Charlotte Foust
-- 
Sent from my Android phone with K-9 Mail. Please excuse my brevity.

jwcolby <jwcolby at colbyconsulting.com> wrote:

Does anyone know of a reason that LIKE is faster with the * in back instead of the front of a string 
to search by in the where clause?

-- 
John W. Colby
www.ColbyConsulting.com
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com




More information about the AccessD mailing list