Re: Will the LIKE operator cause a tablescan?

From: Gjlinker <gjlinker_at_aol.com>
Date: 31 Jan 1999 00:36:38 GMT
Message-ID: <19990130193638.25773.00000810@ngol01.aol.com>

Hi,

These kinds of queries can be resolved by looking at the execution plan. Either read the Oracle documentation on the explain plan utility or have a look at the explain form I put together to make it a bit easier:

Explain can be found at http://members.aol.com/gjlinker

Regards, Gerrit-Jan Linker

In article <78rmlm$dg2$1_at_readme.online.no>, "Paal Berggreen" <paalb_at_softinn.no> writes:

>Will a search using the LIKE operator cause a tablescan if the criteria is
>of type '<text>%'?
>
>-Paal
>
Received on Sat Jan 30 1999 - 18:36:38 CST