Path: news.easynews.com!core-easynews!newsfeed3.easynews.com!easynews.com!easynews!news.glorb.com!postnews2.google.com!not-for-mail
From: andrewst@onetel.net.uk (Tony)
Newsgroups: comp.databases.oracle.misc
Subject: Re: Which one is faster?
Date: 7 Jul 2004 14:39:04 -0700
Organization: http://groups.google.com
Lines: 8
Message-ID: <c0e3f26e.0407071339.2722d548@posting.google.com>
References: <2l1clgF76p3oU1@uni-berlin.de> <phvme0p53ds1h41i8efbgmlqjqj034d6pq@4ax.com> <2l1dfuF7cgu4U1@uni-berlin.de> <c0e3f26e.0407070330.592c8012@posting.google.com> <2l27beF7neelU1@uni-berlin.de>
NNTP-Posting-Host: 80.3.32.6
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1089236345 20377 127.0.0.1 (7 Jul 2004 21:39:05 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Wed, 7 Jul 2004 21:39:05 +0000 (UTC)
Xref: core-easynews comp.databases.oracle.misc:111564
X-Received-Date: Wed, 07 Jul 2004 14:38:14 MST (news.easynews.com)

"Chris \( Val \)" <chrisval@bigpond.com.au> wrote in message news:<2l27beF7neelU1@uni-berlin.de>...
> [snip]
> 
> Are bind variables of any help for this kind of situation ?

No, they have no part to play in this.  What they do is allow you to
execute the same query many times for different values, but parse it
only once.  In this example, we only parse once anyway.