Xref: alice comp.databases.oracle.server:83046
Path: alice!news-feed.fnsi.net!newsfeed.direct.ca!newsfeed.concentric.net!newsfeed.gol.com!nspixp2!spinnewsgate!spinykh!news.pep.ne.jp!news.pep.ne.jp!rd400!not-for-mail
From: "Maki Takahashi" <maki@randd.tjsys.co.jp>
Newsgroups: comp.databases.oracle.server
Subject: Poor Performance when SQL with wild card
Date: Wed, 2 Feb 2000 18:28:27 +0900
Organization: Toshiba Information Systems, Corp., R&D Dept.
Lines: 23
Message-ID: <878t1o$la7$1@rd400.randd.tjsys.co.jp>
Mime-Version: 1.0
Content-Type: text/plain;
 charset="iso-2022-jp"
Content-Transfer-Encoding: 7bit
X-Trace: rd400.randd.tjsys.co.jp 949483384 21831 157.79.101.133 (2 Feb 2000 09:23:04 GMT)
X-Complaints-To: postmaster@randd.tjsys.co.jp
NNTP-Posting-Date: 2 Feb 2000 09:23:04 GMT
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300

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