Create Index myIndex On myTable(myColumn)
What type of Index will get created after executing the
above statement
Answer Posted / mobin sathupally
If we simple say CREATE INDEX then non clustered index will
be created.At the same time if we say CREATE NON CLUSTERED
INDEX then also non clustered index will be created.
Eg.
CREATE TABLE Emp(
eid INT
,ename VARCHAR(20))
CREATE INDEX in_emp_eid
ON Emp(eid)
By executing above code we create non clustered index.
Eg.
CREATE TABLE Emp(
eid INT
,ename VARCHAR(20))
CREATE NONCLUSTERED INDEX in_emp_eid
ON Emp(eid)
By using this code also we create non clustered index only.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is coalesce in sql server?
what protocol both networks use? : Sql server database administration
What are the steps you should follow to start sql server in single-user mode?
Explain something about security and SQL Azure?
What is a non clustered primary key?
Explain the difference between control flow and data flow?
What's the information that can be stored inside a bit column?
What is multi-statement table-value user-defined function?
What is the recovery model? List the types of recovery model available in sql server?
What is the meaning of sql server?
Can you type more than one query in the query editor screen at the same time?
Comment,Datatypes are unlimited
What is a Join and explain its types?
What is extended stored procedures?
What is the New in SQL server 2008?