Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!news.glorb.com!postnews.google.com!u72g2000cwu.googlegroups.com!not-for-mail
From: "Anurag Varma" <avoracle@gmail.com>
Newsgroups: comp.databases.oracle.server
Subject: Re: Why functions in Select Clause affect performance?
Date: 4 Apr 2006 12:20:47 -0700
Organization: http://groups.google.com
Lines: 7
Message-ID: <1144178447.761844.129790@u72g2000cwu.googlegroups.com>
References: <1144174643.540169.119060@t31g2000cwb.googlegroups.com>
NNTP-Posting-Host: 13.13.16.2
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1144178452 19878 127.0.0.1 (4 Apr 2006 19:20:52 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Tue, 4 Apr 2006 19:20:52 +0000 (UTC)
In-Reply-To: <1144174643.540169.119060@t31g2000cwb.googlegroups.com>
User-Agent: G2/0.2
X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.0.1) Gecko/20060111 Firefox/1.5.0.1,gzip(gfe),gzip(gfe)
Complaints-To: groups-abuse@google.com
Injection-Info: u72g2000cwu.googlegroups.com; posting-host=13.13.16.2;
   posting-account=Bjij0w0AAACWMZ9jVkCMjBKLT0Yf1PAH
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:264835


Can you create a simple concise test case to prove/show that?
Please note that the test case has to have that function in
the select clause ONLY.

Anurag