Re: Function-based index on DML-active tables

From: Bjørn Dörr Jensen <B.D.Jensen_at_gmx.net>
Date: Thu, 6 Apr 2006 18:39:44 +0200
Message-ID: <001301c65998$b5ee4430$6701a8c0@camelopardalis>

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

Received on Thu Apr 06 2006 - 11:39:44 CDT