Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to do Indexing of database tables in phpMyAdmin

Tags:

indexing

mysql

I want to boost up my database speed each time when new query hit to database table. Can anybody help me out with how indexing works in phpMyAdmin & how to do it??

like image 923
Codeigniter Developer Avatar asked Dec 19 '22 17:12

Codeigniter Developer


1 Answers

  1. Select a table
  2. click on page Structure
  3. Below the column section you can found an index section
  4. Found the Create an index on x columns
  5. Press the button GO
like image 51
Pavel Zimogorov Avatar answered Jan 12 '23 00:01

Pavel Zimogorov