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

Answer Posted / sanjay

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

Is This Answer Correct ?    5 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain rdbms?

753


Why main is user defined function?

750


Where do we use trace frag?

732


what is the primary use of the model database? : Sql server administration

727


what are statistics, under what circumstances they go out of date, how do you update them? : Sql server database administration

685






Can a synonym name of a table be used instead of a table name in a select statement?

768


To automatically record the time on which the data was modified in a table, which data type should you choose for the column?

718


What do you understand by check constraint in sql server?

648


How many full-text indexes can a table have?

720


How to check parameter value in stored procedure sql server?

657


What is master database? : SQL Server Architecture

709


What the difference between UNION and UNIONALL?

757


how would you troubleshoot blocking? : Sql server database administration

719


How can I track the changes or identify the latest insert-update-delete from a table?

717


Explain index in sql server?

754