CREATE INDEX

1. The CREATE INDEX statement is used to create an Index named "Index" on the "Name" column in the Employee Table.

The basic syntax is as follows:

CREATE INDEX Index_Name ON Table_Name(Column1)

Syntax For SQL:

CREATE INDEX EIndex ON Employee(Name)

 2. If you want to create an index on a combination of columns, you can list the column names within the parentheses, separated by commas:

The basic syntax is as follows:

CREATE INDEX Index_Name ON Table_Name(Column1,Column2)

Syntax For SQL:

CREATE INDEX EIndex ON Employee(Name, salary)

After Execution: 
(1 row(s) affected)
(0 ms taken)

DROP INDEX Command:

An index can be dropped using SQL DROP command. Care should be taken when dropping an index because performance may be slowed or improved.

The basic syntax is as follows:

DROP INDEX index_name; 

Syntax For SQL:

DROP INDEX EIndex;

After Execution: 
(1 row(s) affected)
(0 ms taken)