Do I need to add an index on a mySQL table if the ID column is the primary key? Do I need to add an index on a mySQL table if the ID column is the primary key? mysql mysql

Do I need to add an index on a mySQL table if the ID column is the primary key?


No, you don't need do this.

Primary key is automatically indexed. What you need is to index column that is foreign key in other table.


By default Primary key is working like INDEX KEY.you need not to create this to index key.