Interested to Buy Any Domain ? << Click Here >> for more details...
Create Index myIndex On myTable(myColumn)
What type of Index will get created after executing the
above statement
- 3 Answers
- 8681 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
What do you understand by intent locks?
How do I find the query plan in sql server?
How to test values returned by a subquery with the in operator?
How do I find my localdb version?
How to write a query with an inner join in ms sql server?
What is user-defined multi-statement table-valued function?
Difference between Sql server reporting services and Crystal reports?
What is the language structure to add a record to a table?
How would you choose between a clustered and a non-clustered index?
What are the properties of the transactions?
How can you insert null values in a column while inserting the data?
How to use "if ... Else if ... Else ..." Statement structures in ms sql server?
What is the partitioning method?
What is database dimension? : sql server analysis services, ssas
Explain multiserver query
