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