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 |
How to find the last update record in SQL Server?
Write a SQL Query to find first Week Day of month?
How can you insert null values in a column while inserting the data?
Which operator do you use to return all of the rows from one query except rows are returned in a second query?
Which command is used for user defined error messages?
what is package configuration variable?How to change file name in folder dynamically?Plz help me
Comment,Datatypes are unlimited
What is the difference between cross join and Full outer join?
Can you tell me the difference between DELETE & TRUNCATE commands?
What is ms sql server index?
What is a full text index?
Explain the collation?