Originally posted by aj_usa
Hi Friends,

Can somebody suggest recommended practice for creating custom indexes on oracle tables ??
What tables specifically and why? If you're talking about objects owned by SYS or SYSTEM, you just don't do it. That's the best practice.

If you're talking about Oracle "applications" - tables owned by APPLSYS - that's another story. There are some naming conventions that are recommended which help during upgrades. Haven't worked on apps for sometime now..