Create Index myIndex On myTable(myColumn)
What type of Index will get created after executing the
above statement
Answers were Sorted based on User's Feedback
Answer / swapna
Non-clustered index. Important thing to note: By default a
clustered index gets created on the primary key, unless
specified otherwise.
Is This Answer Correct ? | 3 Yes | 0 No |
Answer / 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 |
What does truncate do?
What is the difference between having clause and where clause in sql server?
How to get a list of columns in a view using the "sp_columns" stored procedure?
What is the bookmark lookup and rid lookup?
how can you move the master database
How can sql server instances be hidden?
What is a system database and what is a user database?
Do you know the different ddl commands in sql?
What is a Linked Server?
Differentiate between delete and truncate.
hi i gone though satyam interview. what is Acid Properties?
what's new in sql server 2016?