RE: tuning query with concat string.

From: Jim Silverman <jsilverman_at_Solucient.com>
Date: Tue, 21 Mar 2006 10:22:53 -0500
Message-ID: <2D1EFB433A527D4681B80C94B71E3598043A69F5@aaexchange01.HEALTH.AD>

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_at_solucient.com

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] 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."
--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Tue Mar 21 2006 - 09:22:53 CST