Re: Function-based index on DML-active tables
- From: Bjørn Dörr Jensen <B.D.Jensen@xxxxxxx>
- To: <Amir.Hameed@xxxxxxxxx>, "Dennis Williams" <oracledba.williams@xxxxxxxxx>
- Date: Thu, 6 Apr 2006 18:39:44 +0200
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
To: Dennis Williams
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:
