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@xxxxxxx] *Sent:* Thursday, April 06, 2006 12:40 PM *To:* Hameed, Amir; Dennis Williams *Cc:* oracle-l@xxxxxxxxxxxxx *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@xxxxxxxxx> *To:* Dennis Williams <mailto:oracledba.williams@xxxxxxxxx> *Cc:* oracle-l@xxxxxxxxxxxxx <mailto:oracle-l@xxxxxxxxxxxxx> *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@xxxxxxxxx]
*Sent:* Wednesday, April 05, 2006 3:30 PM
*To:* Hameed, Amir
*Cc:* oracle-l@xxxxxxxxxxxxx <mailto:oracle-l@xxxxxxxxxxxxx>
*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
-- //www.freelists.org/webpage/oracle-l