Path: text.usenetserver.com!out03b.usenetserver.com!news.usenetserver.com!in02.usenetserver.com!news.usenetserver.com!postnews.google.com!news2.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!nx01.iad01.newshosting.com!newshosting.com!post01.iad01!not-for-mail Date: Sun, 09 Sep 2007 09:58:13 -0700 From: DA Morgan Organization: Puget Sound Oracle Users Group User-Agent: Thunderbird 2.0.0.6 (Windows/20070728) MIME-Version: 1.0 Newsgroups: comp.databases.oracle.server Subject: Re: Question on 8.1.7 References: <1189354836.746350.308770@d55g2000hsg.googlegroups.com> In-Reply-To: <1189354836.746350.308770@d55g2000hsg.googlegroups.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Message-ID: <1189357085.354262@bubbleator.drizzle.com> Cache-Post-Path: bubbleator.drizzle.com!unknown@216.162.218.178 X-Cache: nntpcache 3.0.1 (see http://www.nntpcache.org/) Lines: 32 X-Complaints-To: abuse@csolutions.net Xref: usenetserver.com comp.databases.oracle.server:434657 X-Received-Date: Sun, 09 Sep 2007 12:58:05 EDT (text.usenetserver.com) Gokul wrote: > Hello, > > We hit a strange problem on version 8.1.7. > > select col1,col2,col3 from tab1,view1,tab2.. where col5 >= '08-Sep-07' > > select col1,col2,col3 from tab1,view1,tab2.. where col5 >= > to_date(to_char(sysdate-1,'YYYYMMDD'),'YYYYMMDD') > > These two queries behave differently. The first one takes less than 2 > secs and the second one takes 15 minutes. > > I dont have more details. Just trying my luck here to check if someone > has faced such problem in the past. > > Any ideas ? > > PS: '08-Sep-07' and (sysdate - 1) are same. > > Rgds, > Gokul EXPLAIN PLAN Post it. -- Daniel A. Morgan University of Washington damorgan@x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.org