Sai Reddy

Sai Reddy

  • NA
  • 214
  • 31k

What is the default index ?

May 10 2018 3:17 AM
Create table tblEmployee
(
ID int primary key,
Name nvarchar(50),
Gender nvarchar(50),
Salary int,
DepartmentId int 
)
 --Creating index on salary column
 
create index  index_on_salary  on tblemployee(Salary Asc) 
 
Question : Which index will get created here? 

Answers (3)