RE: Function-based index on DML-active tables

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 
                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
                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

Other related posts: