Re: Will the LIKE operator cause a tablescan?

Not if you have any index on the column. This '%<text>' will.

Please note that it may not be efficient using the index searching with for instance 'S%'.

Niklas

Paal Berggreen wrote in message <78rmlm$dg2$1_at_readme.online.no>...
>Will a search using the LIKE operator cause a tablescan if the criteria is
>of type '<text>%'?
>
>-Paal
>
>
Received on Fri Jan 29 1999 - 02:08:36 CST