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 are the two modes of authentication in sql server?
What is RAID and what are different types of RAID configurations?
What type of locking occurs during the snapshot generation? : sql server replication
hi i am working as a testengineer , so i want to no the backend data base connection can any one tell mwe in detail
What are the dis_advantages of stored procedures, triggers, indexes?
Can a database be shrunk to 0 bytes, if not, why?
WHICH IS THE BEST INSTITUTE IN HYD FOR "ORACLE"?
How is a full-text index updated?
How to transfer a table from one schema to another?
Can the “if update (colname)” statement be used in a delete trigger?
What is data compression?
Explain “not null constraint” in sql server?