Path: text.usenetserver.com!out02a.usenetserver.com!news.usenetserver.com!in02.usenetserver.com!news.usenetserver.com!postnews.google.com!m36g2000hse.googlegroups.com!not-for-mail From: Dion Cho Newsgroups: comp.databases.oracle.server Subject: Re: LIKE operator on CHAR column when there is no wildcard character Date: Mon, 7 Jul 2008 01:12:14 -0700 (PDT) Organization: http://groups.google.com Lines: 8 Message-ID: <8375f7ae-fd29-4c27-b775-897b9712c83c@m36g2000hse.googlegroups.com> References: NNTP-Posting-Host: 210.122.227.246 Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Trace: posting.google.com 1215418335 14069 127.0.0.1 (7 Jul 2008 08:12:15 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: Mon, 7 Jul 2008 08:12:15 +0000 (UTC) Complaints-To: groups-abuse@google.com Injection-Info: m36g2000hse.googlegroups.com; posting-host=210.122.227.246; posting-account=vlNgZgoAAABUA2sGdDiFIzLsGlhIZZr8 User-Agent: G2/1.0 X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; ko; rv:1.9) Gecko/2008052906 Firefox/3.0,gzip(gfe),gzip(gfe) Xref: usenetserver.com comp.databases.oracle.server:446298 X-Received-Date: Mon, 07 Jul 2008 04:12:15 EDT (text.usenetserver.com) Murty, would you mind giving more info? 1. Do you use literal values? 2. How many distinct values for like 'xxx' condition? Dion Cho