Re: Making use of an Index with the rtrim function in the where clause

From: Peter Sharman <psharman_at_us.oracle.com>
Date: Tue, 02 Mar 1999 11:38:10 -0800
Message-ID: <36DC3E22.661EADEA@us.oracle.com>

As Thomas says, this is available in 8i. The approach I've used prior to 8i is to create a "hidden" column, populate the hidden column with the function value (rtrim(colname)) via a trigger, index the hidden column and report on that. Messy, but it gets you there.

HTH. Pete

Prabhakar wrote:

> Hi!
> I am trying to use a column inside the Rtrim function in sql query's
> where clause,I have an index for that column,I read from sql tuning
> books that Oracle will not use the index if the column is embedded
> within a function call like upper,is null etc.
> How do I force Oracle to make use of that Index?...
>
> Please do give me your valuable suggesstions on this.
>
> Thanks in advance.
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own

Regards

Pete

Peter Sharman                              Email: psharman_at_us.oracle.com
WISE Course Development Manager            Phone: +1.650.607.0109 (int'l)
Worldwide Internal Services Education               (650)607 0109 (local)

San Francisco

"Controlling application developers is like herding cats." Kevin Loney, ORACLE DBA Handbook
"Oh no it's not! It's much harder than that!" Bruce Pihlamae, long term ORACLE DBA

Received on Tue Mar 02 1999 - 13:38:10 CST