RE: tuning query with concat string.
- From: "Jim Silverman" <jsilverman@xxxxxxxxxxxxx>
- To: <sjaffarhussain@xxxxxxxxx>, "oracle-l" <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 21 Mar 2006 10:22:53 -0500
First, what are you hoping to accomplish by rewriting it? Is there an
index on 'COLUMN' that is not being used because of the expression in
the WHERE clause? Is there another factor that you are trying to
address?
=====================================
Jim Silverman
Senior Systems Database Administrator
Solucient, LLC
Telephone: 734-669-7641
FAX: 734-930-7611
E-Mail: jsilverman@xxxxxxxxxxxxx
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of The Human Fly
Sent: Tuesday, March 21, 2006 10:10 AM
To: oracle-l
Subject: tuning query with concat string.
Hello list,
How can I rewrite the query which uses concatenation in the where
clause? For an example,
SELECT ...... FROM where COLUMN = 'S'||'VALUE2';
Thanks for your time.
--
Best Regards,
Syed Jaffar Hussain
8i,9i & 10g, OCP DBA
Banque Saudi Fransi,
Saudi Arabia
http://jaffardba.blogspot.com/
------------------------------------------------------------------------
----------
"Winners don't do different things. They do things differently."
--
//www.freelists.org/webpage/oracle-l
Other related posts:
