sqlexplore.wordpress.com
SQL SERVER – CREATE INDEX myIndex ON myTable(myColumn)What type of Index will get created after executing the above statement
Non-clustered index. Important thing to note: By default a clustered index gets created on the primary key, unless specified otherwise. Reference : Dilip Kumar Jena (