Possible Duplicate:
What is the SQL index name for?

create index IDX_testNoPK_Name on testNoPK (name)

I am talking about what's the purpose of index title ?

Why the index requires a title ?

Indexes need names for the similar reasons than anything else (databases, tables, posts, customers...): so that you can later make reference to them.

Some situations where you'll need a mention of the a catalog include:

  • Whenever you violate a set limit and MySQL must let you know which.
  • Whenever you generate an explain plan and wish to understand what indexes are used.
  • When you wish to decrease the index.

The title is IDX_testNoPK_Title !

CREATE INDEX IndexName on TableName (FieldName)

Index title are utilized to read Execution Plan, which states you when a catalog can be used.

The title is print around the Execution Plan, so a great naming convention on Index title will help you completely understand what your query do.

Possible Duplicate : What is the SQL index name for?

A catalog title is needed to recognize it. Naming a catalog enables you to definitely execute actions regarding this as modify, rebuild, shrink.

Without naming indexes could be impossible to produce some type of scripts.

IDX_testNoPK_Title may be the index Reputation for your table