Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I am assuming that a secondary index in MySQL is the same thing as a non-clustered index in SQL Server.

Is this true?

share|improve this question
add comment

migrated from stackoverflow.com Jan 7 '13 at 1:45

This question came from our site for professional and enthusiast programmers.

2 Answers

http://dev.mysql.com/doc/refman/5.0/en/innodb-index-types.html

In InnoDB, the records in nonclustered indexes (also called secondary indexes) contain the primary key columns for the row that are not in the secondary index. InnoDB uses this primary key value to search for the row in the clustered index. If the primary key is long, the secondary indexes use more space, so it is advantageous to have a short primary key.

Could have just searched for this.

share|improve this answer
1  
I did a couple of Google / StackOverflow searches and there were no immediate results so I thought I start a question for future search engine references –  Lloyd Banks Jan 6 '13 at 23:35
add comment
up vote 0 down vote accepted

Got an answer through another forum. They are indeed the same

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.