Poor Performance when SQL with wild card

From: Maki Takahashi <maki_at_randd.tjsys.co.jp>
Date: Wed, 2 Feb 2000 18:28:27 +0900
Message-ID: <878t1o$la7$1@rd400.randd.tjsys.co.jp>

I'm now using SQLServer 6.5 and trying to move to Oracle8. but its performance is tremendously bad... only the case using wild card like

select * from table where col like '%aaa%'

SQLServer 6.5     3 minutes
SQL          7.0    30 min
Oracle8             more than 30 min

sometimes Oracle fails to return the result set when it includes so many records.
DB tuning and index tuning which I did were not effective at all.

I can't have any clue for tuning now. but I have to do version up anyway. Is that unavoidable to be poor performance on Oracle8 ? or any solution we have?

thanks.

// Maki Takahashi Received on Wed Feb 02 2000 - 03:28:27 CST