T
T
TarasUK2015-08-05 12:08:06
MySQL
TarasUK, 2015-08-05 12:08:06

Do I need to index incremental Ids mysql, MyISAM?

Table 6.5 *10^6 records 2.9 Gb
primary key `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
Table only for most selects by ID.
Attention to the question: will there be a performance increase in such hands?

Answer the question

In order to leave comments, you need to log in

1 answer(s)
R
Rsa97, 2015-08-05
@TarasUK

PRIMARY KEY is already an index of type UNIQUE

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question