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
- 8784 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
Can you use order by when defining a view?
How to get a list of columns using the "sp_help" stored procedure in ms sql server?
What are the tool windows in sql server management studio? : sql server management studio
What kind of problems occurs if we do not implement proper locking strategy?
How do I view a stored procedure in sql server?
How do I port a number to sql server?
How do you create a data source?
How many replicas are maintained for each SQL Azure database?
What part does database design plays a role in performance of an sql server-based application?
what are cursors? : Sql server database administration
tell me the disaster recovery plan
Explain query editor regions
How to create database with physical files specified in ms sql server?
How we can refresh the view?
What is bit data type?
