SQL Index

 1. CLUSTER INDEX:- best optimization search on primary key. 

Syntax- Create Cluster Index Ix_EmpId ON Employee(eid).

2. Non- Cluster Index- best optimization search on non primary key. 

Syntax- Create NonCluster Index Ix_Department ON Employee(Department).

3. Unique Index:- best optimization search on unique key. 

Syntax- Create Unique Index Ix_Email ON Employee(Email).

4. Composite Index:- best optimization search on multiple columns.  

Syntax- Create NonCluster Index Ix_Dept_HireDate ON Employee(Department, HireDate).

Select * from Employees Where Department = 'HR' and HireDat

e> '2002-01-01';