DBAzine.com

Sections

Personal tools

You are not logged in
Log in
Join

You are here: Home » Blogs » Chris Foot Blog » Chris Foot's Oracle10g Blog » The Non-Technical Art of Being a Successful DBA - Naming Conventions » Index Naming Conventions

Seeking new owner for this high-traffic DBAzine.com site.
Tap into the potential of this DBA community to expand your business! Interested? Contact us today.

Who Are You?

I am a:
[ Results | Polls ]
Votes : 3640

Comment

Above in this comment thread: The Non-Technical Art of Being a Successful DBA - Naming Conventions » Naming Conventions

Index Naming Conventions

Posted by cfoot at 2006-09-10 06:42 AM

My personal preference is to not use column names in indexes. It makes them too long. I prefer a standard naming convention that uses the table name in the index name and then an identifier to denote the specific index. As you stated, the column names can be easily identified from the data dictionary.

You usually end up abbreviating the column names so much that you really can't tell what the column names are.