Create Index myIndex On myTable(myColumn)
What type of Index will get created after executing the
above statement
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 is postgresql server?
Explain the truncate command?
State a few properties of relational databases?
What is a non-clustered index?
How do you rename a table in sql server?
Show Practically Sql Server Views are updatable?
Can we write ddl in trigger?
how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A
What is the difference between local and global temporary tables?
How can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role?
Explain can you implement data mining in ssrs?
What are the five characteristics of good data?
What is master database? : SQL Server Architecture
What is the maximum size of sql server database?
What is the sql server 2000 version number?