Re: Function-based index on DML-active tables

Check out: http://www.active-base.com/
They have a product, active-knowledge, that let you catch the sql between the server and the database and change it. Probably overkill in your case but can help a lot in changing canned application code to more efficient sql.

Just say that Yechiel Adar sent you. :-)

Just kidding, I am not involved with the company.

Adar Yechiel
Rechovot, Israel

Hameed, Amir wrote:

> I agree but this is an Oracle applications code and getting
> execute via OCI.
>
> ------------------------------------------------------------------------
> *From:* Bjørn Dörr Jensen [mailto:B.D.Jensen_at_gmx.net]
> *Sent:* Thursday, April 06, 2006 12:40 PM
> *To:* Hameed, Amir; Dennis Williams
> *Cc:* oracle-l_at_freelists.org
> *Subject:* Re: Function-based index on DML-active tables
>
> Hi!
> Wouldn't it be better to manipulate the sql instead of making an
> fbi, eg:
> replace select * from a where b=2 with select * from a where
> b='2'...?
> /Greetings
> Bjørn
>
> ----- Original Message -----
> *From:* Hameed, Amir <mailto:Amir.Hameed_at_xerox.com>
> *To:* Dennis Williams <mailto:oracledba.williams_at_gmail.com>
> *Cc:* oracle-l_at_freelists.org <mailto:oracle-l_at_freelists.org>
> *Sent:* Wednesday, April 05, 2006 10:23 PM
> *Subject:* RE: Function-based index on DML-active tables
>
> Dennis,
> It is a very simple function; to_char(<column_name>)
>
> Thanks
> ------------------------------------------------------------------------
> *From:* Dennis Williams [mailto:oracledba.williams_at_gmail.com]
> *Sent:* Wednesday, April 05, 2006 3:30 PM
> *To:* Hameed, Amir
> *Cc:* oracle-l_at_freelists.org <mailto:oracle-l_at_freelists.org>
> *Subject:* Re: Function-based index on DML-active tables
>
> Amir,
>
> I think the answer depends on the complexity of your
> function. If it is simple, then there probably is little
> penalty. If you get carried away with a very complex
> function, well all bets are off.
>
> Dennis Williams
>

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