ainpoissee wrote:

> I do have a habit to use prefixes for object names, ie table name starts with TAB_, view's with VIEW_ etc... I tougth that index compression sheme would optimize away the common prefix so it wouldn't make any noticeable difference, but is this is really the case? Or would it be better to drop the prefix (or use common suffix if I really want to have hint of the object type in it's name)?
>

Yes, prefix compression will eliminate those tags in indexes.
but they have the side-effect of crippling views as a mechanism to
allow schema changes without affecting existing applications.

Good luck,

Ann