Is it OK to name a MySQL index the same as the column it indexes?

mysql relational-database indexing
sqlman picture sqlman · Jun 27, 2011 · Viewed 14.6k times · Source

Is it considered bad form to give an index the same name as the column it is based on?

Like if you have a column named 'foo' and you want to create a normal index on it, would it be okay to name the index 'foo'? MySQL doesn't complain, but I am wondering what the pros and cons are.

Answer

OMG Ponies picture OMG Ponies · Jun 27, 2011

The convention doesn't matter so much as that you are consistently using it.

That said, I prefix index names with "ind_"; Constraints get the "cns_" prefix. In either case, the column name(s, if composite/covering).

Related questions

MySQL Indexing, Different types and when to use them?

Ok, So I have (re)searched a lot regarding MySQL Indexes and their importance and I understand i have to use it to make database queries run faster., And i know the syntax to add index on any filed. But …

Read More
How to create relationships in MySQL

In class, we are all 'studying' databases, and everyone is using Access. Bored with this, I am trying to do what the rest of the class is doing, but with raw SQL commands with MySQL instead of using Access. I …

Read More
Setting up table relations what do "Cascade", "Set Null" and "Restrict" do?

I want to start using table relations in a new project. After some googling I got 2 tables set up as InnoDB: The keys I want to link are ->users->userid (primary) ->sessions->userid (index) …

Read More