Which index created when Create Index on table(col), Why

Answers were Sorted based on User's Feedback



Which index created when Create Index on table(col), Why..

Answer / indexes

Non Clustered Index by Default.

Is This Answer Correct ?    15 Yes 0 No

Which index created when Create Index on table(col), Why..

Answer / sanjay

whenever you create index without specifying the type, its
non-clustered.

Is This Answer Correct ?    5 Yes 0 No

Post New Answer

More SQL Server Interview Questions

What is partition in sql server?

0 Answers  


Explain some stored procedure creating best practices or guidelines?

0 Answers  


What is plan freezing?

0 Answers  


What is a partitioned view?

0 Answers  


What are the differences between triggers and stored procedures?

0 Answers  






Define msdb database?

0 Answers  


What is snapshot replication?

0 Answers  


What is difference between rownum and rowid?

0 Answers  


What is the difference between function and stored procedure in sql server?

0 Answers  


What is model database in sql server?

0 Answers  


How you can change a cross join into an inner join?

0 Answers  


Why people hate cursor?

0 Answers  


Categories