Index Naming Standards

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

shsandeep - 18 Apr 2006 02:42 GMT

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.

Reply to this Message

lennart@kommunicera.umea.se - 18 Apr 2006 07:10 GMT

> Hi all,
> I need a proper index naming standard for my database (datawarehouse).
[quoted text clipped - 8 lines]
> 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

Reply to this Message