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 ms sql server index?
Write a query to find 5th highest amount paid from the customer table.
How display code or Text of Stored Procedure using Sql query in Sql Server ?
What are the disadvantages of indexes?
Do you know what is fill factor and pad index?
Does the order of columns in update statements matter?
Explain the Ways to improve the performance of a sql azure database?
List the data types available in mssql?
How to disconnect from a sql server using mssql_close()?
What does set rowcount do?
What is right outer join in sql server joins?
How do I start sql server 2017?
Define outer join in sql server joins?
What are temporal tables in sql server 2016?
Explain different types of locks in sql server.