On 4/6/06, Hameed, Amir <Amir.Hameed_at_xerox.com> wrote:
>
> Folks,
> I am trying to understand the impact of creating a function-based index
> on an order entry table which is heavily used by DML statements. Can
> anyone tell me the downside of creating such an index?
>
> Any help will be appreciated.
> Thanks
> Amir
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
Why not conduct two simple benchmarks
- create index IX on MY_TABLE ( col)
- create index IX on MY_TABLE ( to_char(col))
and in each case, whack millions of updates, inserts, deletes at it. I'm
contending (without having done the benchmark myself) that the difference
between (a) and (b) will be negliigble, which would thus give you confidence
that IF the overhead of an extra index is OK, then you've got a green light
for the FBI.
--
Connor McDonald
===========================
email: connor_mcdonald_at_yahoo.com
web: http://www.oracledba.co.uk
"Semper in excremento, sole profundum qui variat"
--
http://www.freelists.org/webpage/oracle-l
Received on Mon Apr 17 2006 - 07:18:05 CDT
