First page Back Continue Last page Image

It is a Table so you Need to Name it Accurately

While there is no absolute rule for naming Indexes, there are a few guidelines that will make the Indexes usable by other people

tablename_fieldname_commonsuffix

Ships_shipClass_ix

Her we are going to take our Star Trek “Ships” table

and create an Index on the “shipClass” field

Here we use an “ix” suffix on all indexes

Random or unregulated index naming can result in the proliferation of redundant tables cluttering your database