Index Naming Standards

[shsandeep]

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.

[len...@kommunicera.umea.se]

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