Performance like against = (equal sign)

From: Nicolas Bronke <newsgroup_at_trinity.de>
Date: Tue, 19 Oct 1999 11:47:27 +0200
Message-ID: <380c30b6_4@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 - 04:47:27 CDT