INDEXES

---

MySQL - Indexes

An index is a performance-tuning method of allowing faster retrieval of records. An index creates an entry for each value that appears in the indexed columns.

SYNTAX :

CREATE INDEX [index name] ON [table name]([column name]);

Create INDEX :

CREATE INDEX StudentID ON studentrecord(StudentID);

Index gets created as we check indexes in the respective table.In Case it is not visible please refresh the object explorer so that you can see the created INDEX.

Create UNIQUE INDEX :

CREATE  UNIQUE INDEX newStudentID ON studentrecord(StudentID);

As a result,UNIQUE INDEX gets created.