About Lesson
select * from tblemp;
/*
Create Index: Index help us to fetch the data fast. or decrease the query expense.
syntax:
create index index_name
on tablename(coloumnname ASC|DESC)
*/
create index IX_emp_sal
on tblemp(sal asc);
— check index report on a table
exec sp_help tblemp
— to drop an index
— syntax: drop index tablename.indexname