Create Index myIndex On myTable(myColumn)
What type of Index will get created after executing the
above statement
- 3 Answers
- 8205 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
Where cross join is used?
Explain can you implement data mining in ssrs?
How to create a new schema in a database?
How to enable tcp/ip protocol on a sql server?
What is the contrast between sql and pl/sql?
What is acid db?
What are unicode character string data types in ms sql server?
Explain “@@rowcount” and “@@error” in sql server?
How you can get a list of all the table constraints in a database? : Sql server administration
What languages bi uses to achieve the goal?
What are the methods used to protect against sql injection attack?
How can sql injection be stopped? : sql server security
What is the concept of optimization?
what is a traditional network library for sql servers? : Sql server database administration
What is encryption key?
