[AccessD] xyz* faster than *asd

Like Drew my answer is: if you have no index on the field there will be
no difference to performance because the query engine then has to do a
table scan. But if you have an index on the field then the query engine
can use the index for LIKE xyz*, but it has to do a table scan for LIKE
*xyz.
Asger

----- Original meddelelse -----

> Fra: jwcolby <jwcolby at colbyconsulting.com>
> Til: Access Developers discussion and problem solving
> <accessd at databaseadvisors.com>
> Dato: Fre, 08. jul 2011 19:24
> Emne: [AccessD] xyz* faster than *asd
> 
> 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