CODEWITHSUNDEEP
mysqlindexing
Codeigniter Developer
Codeigniter Developer

Reputation: 91

How to do Indexing of database tables in phpMyAdmin

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??

Upvotes: 9

Views: 28646

Answers (3)

George B.
George B.

Reputation: 312

Set the index from PHPMYADMIN.

I marked the index button in yellow.

enter image description here

Upvotes: 3

ravnur
ravnur

Reputation: 2852

you can use create index statement:

create index idx_username on users(username)

what actually means: "i want to create index called idx_username on table users on column username"

Upvotes: 6

Pavel Zimogorov
Pavel Zimogorov

Reputation: 1442

  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

Upvotes: 11

Related Questions