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.



MySQL TRIGGERS

MySQL - Triggers

posted on 2019-11-29 21:44:07 - mysql Tutorials


Grant_ Revoke Privilege

MySQL - Grant_ Revoke Privilege

posted on 2019-11-26 23:15:04 - mysql Tutorials


MySQL Vs SQL

MySQL Vs SQL

posted on 2019-11-25 05:02:26 - mysql Tutorials


What Is Oracle

What Is Oracle

posted on 2019-11-29 01:11:21 - ORACLE Tutorials


TRIGGER

ORACLE - Trigger

posted on 2019-11-28 22:14:22 - ORACLE Tutorials


CURSOR

ORACLE - Cursor

posted on 2019-11-28 22:13:54 - ORACLE Tutorials