If we simple say CREATE INDEX then non clustered index will be created.At

Create Index myIndex On myTable(myColumn)
What type of Index will get created after executing the
above statement

Question Posted / mobin sathupally

3 Answers
8937 Views
I also Faced
E-Mail Answers

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

Please Help Members By Posting Answers For Below Questions

What is ms sql server index?

1149

Write a query to find 5th highest amount paid from the customer table.

986

How display code or Text of Stored Procedure using Sql query in Sql Server ?

1195

What are the disadvantages of indexes?

1152

Do you know what is fill factor and pad index?

1043

Does the order of columns in update statements matter?

954

Explain the Ways to improve the performance of a sql azure database?

List the data types available in mssql?

1101

How to disconnect from a sql server using mssql_close()?

1165

What does set rowcount do?

959

What is right outer join in sql server joins?

1216

How do I start sql server 2017?

984

Define outer join in sql server joins?

988

What are temporal tables in sql server 2016?

928

Explain different types of locks in sql server.

1127