MySQL Index 1

The best index is to improve the query speed of the data in the table, as important as the directory of the book, you can quickly find the required knowledge.

Above is a table of more than 110,000 data, using a statement query, such as:

Time: 0.108s

Another example:

Spents: 0.004s

Next, create the index:

Right-click on the T_book and select Manage Indexes:

Select NEW:

The indexing option is set to BookName:

Click Apply-Save.

Then we are using the first statement to see:

SELECT * from T_book WHERE bookname= ' test book title 5 ';

Do not index the original spents 108 milliseconds:

1 milliseconds to add an index:

The speed has increased by more than 100 times.

So MySQL performance is good, especially after optimization.

To delete an index:

Right-manage indexes on the T_book table-Tick and delete-save.

MySQL Index 1