Re: Performance like against = (equal sign)

From: Sybrand Bakker <postmaster_at_sybrandb.demon.nl>
Date: Tue, 19 Oct 1999 12:34:33 +0200
Message-ID: <940329291.8487.0.pluto.d4ee154e@news.demon.nl>

Hi Nicolas,
Please post the explain plan results and we may be able to find out what happened.

Regards,

--
Sybrand Bakker, Oracle DBA
Nicolas Bronke <newsgroup_at_trinity.de> wrote in message news:380c30b6_4_at_news2.prserv.net...
> Normally I thought, Oracle optimize the select statements, so that oracle
> replace the like statement with the equal sign if possible. But now I
> mentioned on a database 8.04 how slow it could be.
>
> It was a view (not very complex) where the master table has around 7000
rows
> and the detail around 130 rows).
> a select count(*) from this view was unbelieveable slow.
>
> The same view on my other database (Ora 7.3.3) and with more than 16000
rows
> returns the answer immediatly.
>
> Then I replaced the like statement with the equal sign. Now Oracle 8.04
runs
> quickly too.
>
> Did I misunderstand something?
>
> Regards
> Nicolas Bronke
>
>
>
Received on Tue Oct 19 1999 - 05:34:33 CDT