Any use indexing LEFT(Name,10) when Name is indexed ???
Divers
Thread ID:
00142379
Message ID:
00142379
Vues:
59
Hi,
We have an index on the field 'Name'. If we are using LEFT(Name,10) when performing a search, is it faster if we create an index on this expression or can the search use the index on Name ??
