CREATE INDEX myIndex ON myTable(myColumn)

Posted by

To view Verified answers click on the button below.

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.