Re: Designing indexes

> Actually developers create indexes when needed
>and we ended up with tens of indexes for each table >that degrade performance since Oracle is not able >to choose the right one. To put order manually in >such a mess will take many months.

If you can have tens of indexes for each table I wonder about the design process. Sounds like you need a gatekeeper production DBA for implementation, too. Sounds like it needs the many months.

Listen to Hans, Mark and hpuxrac.

jg

--
@home.com is bogus.
"What happened to your crystal ball?"
"I upgraded to a liquid crystal display." - Wizard of Id.