Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.icl.net!colt.net!news.tele.dk!feed118.news.tele.dk!postnews.google.com!i39g2000cwa.googlegroups.com!not-for-mail
From: Martin.Choma@gmail.com
Newsgroups: comp.databases.oracle.server
Subject: Re: Index Range Scans....
Date: 3 Mar 2006 07:04:53 -0800
Organization: http://groups.google.com
Lines: 16
Message-ID: <1141398293.507605.120290@i39g2000cwa.googlegroups.com>
References: <1141391689.633706.102630@z34g2000cwc.googlegroups.com>
   <46r19kFc2r87U1@individual.net>
   <1141397852.165517.81340@i39g2000cwa.googlegroups.com>
NNTP-Posting-Host: 194.228.18.137
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1141398299 23947 127.0.0.1 (3 Mar 2006 15:04:59 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Fri, 3 Mar 2006 15:04:59 +0000 (UTC)
In-Reply-To: <1141397852.165517.81340@i39g2000cwa.googlegroups.com>
User-Agent: G2/0.2
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; .NET CLR 1.1.4322),gzip(gfe),gzip(gfe)
X-HTTP-Via: 1.0 PRXUSR01
Complaints-To: groups-abuse@google.com
Injection-Info: i39g2000cwa.googlegroups.com; posting-host=194.228.18.137;
   posting-account=5FgfiA0AAACYb07se6GB0rutqZLVb7mw
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:262700

I have just hypotetical and no experience-based idea and maybe it is
absolute nonsens. Maybe when you use older Oracle version with RBO, so
condition order can play performance issue. As i know Oracle parse
condition from back to front. what if you try this?

where       LD.f1 = L.F1
and          LD.f2 = L.F2
and          LD.f3 = 'Z'
and          L.f1 = 1139
and          L.f2 = 21

As maybe oracle during creating execution plan doesnt know that L.f1
and L.f2 is known. Please do not lynch me if it is absolute nonsense
:). But still what version do you use. RBO or CBO?  
Martin