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 display n-1 columns from n number of columns, from a single table in MS SQL server 2005?
What is plan freezing?
What is inner join? Explain with an example?
How do I clean up sql server transaction log?
What is Pointer ?
3 Answers Cap Gemini, CarrizalSoft Technologies,
Can a stored procedure call itself or a recursive stored procedure? How many levels of sp nesting is possible?
When do you use SQL Profiler?
What does it mean to normalize data?
How to download microsoft sql server 2005 express edition?
If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?
What are the tool windows in sql server management studio? : sql server management studio
What is sql injection? How to protect against sql injection attack?