Re: Bind variable and the "like" operator

From: Christian Kleinewaechter <christian.kleinewaechter_at_USEDEASTLDtelefonica>
Date: Thu, 24 Feb 2005 16:49:01 +0100
Message-ID: <421df76d$0$18073$750803fa@corp.news.telefonica.de>

Mark D Powell wrote:
> No, the use of a bind variable in the like does not force the CBO to
> always perform a full table scan instead of use the index, if one is
> available. That decision depends on the statistics for the indexed
> columns, other where clause conditions, and the usual factors that
> influence the optimizer.
>

Thanks for your answer. After reviewing my own post I realized that it was in fact the "select from dual" that was explained. I promise to read my test results more carefully next time ;-)

Christian Received on Thu Feb 24 2005 - 09:49:01 CST