3
Answers

What is the default index ?

Photo of Sai Reddy

Sai Reddy

7y
514
1
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)