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