By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,924 Members | 1,727 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,924 IT Pros & Developers. It's quick & easy.

Index Naming Standards

P: n/a
Hi all,
I need a proper index naming standard for my database (datawarehouse).

This is what I have thought so far:
Table name: TGL_MTR_VHCL
Index name: XGL_MTR_VHCL

I am just replacing a 'T' for table with a 'X' for an index.
But the problem occurs when there are multiple indexes on the same table.
How to differentiate them meaningfully? Some proper suffix needs to be in
place.

Just in search of better ideas and methods that anyone of you might have
used before.

Cheers,
San.

Apr 18 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a

shsandeep wrote:
Hi all,
I need a proper index naming standard for my database (datawarehouse).

This is what I have thought so far:
Table name: TGL_MTR_VHCL
Index name: XGL_MTR_VHCL

I am just replacing a 'T' for table with a 'X' for an index.
But the problem occurs when there are multiple indexes on the same table.
How to differentiate them meaningfully? Some proper suffix needs to be in
place.


Here's what I do (though it is not a dw). Tables are given descriptive
names, and I use singular. Example:

CUSTOMER
ACCOUNT

For indexes I use:

XPK<tablename>, for primary key index (Primary Key)
XAKn<tablename>, for other unique indexes, (Alternative Key)
XIEnm<tablename>, for non unique indexes (Inversion Entry)

n, nm is a 1- or 2- digit integer, and since the allowed names for
indexes are shorter than for tables, I usually end up using
abrevations. Example:

X03CUST_ACCNT
HTH
/Lennart

Apr 18 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.