469,315 Members | 1,564 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,315 developers. It's quick & easy.

Index Naming Standards

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
1 2073

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.

Similar topics

3 posts views Thread by C# Learner | last post: by
4 posts views Thread by Mark Broadbent | last post: by
3 posts views Thread by clintonG | last post: by
9 posts views Thread by kevininstructor | last post: by
114 posts views Thread by Jonathan Wood | last post: by
35 posts views Thread by Smithers | last post: by
17 posts views Thread by Miguel Guedes | last post: by
reply views Thread by harlem98 | last post: by
reply views Thread by harlem98 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.