syntax difference between create index and create clustered index

• gary1

  SSC-Insane

  Points: 21152

  More actions

  May 21, 2013 at 11:50 am

  #273009

  Is there any difference if I say Create index and create nonclustred index? or both means same?

  ex:

  CREATE INDEX IX_ProductVendor_VendorID

  ON Purchasing.ProductVendor (VendorID);

  GO

  CREATE NONCLUSTERED INDEX IX_ProductVendor_VendorID

  ON Purchasing.ProductVendor (VendorID);

  GO

• Lowell

  SSC Guru

  Points: 323522

  More actions

  May 21, 2013 at 11:56 am

  #1617131

  they are both the same, the keyword NONCLUSTERED is optional and is the default value when you create a new index.

  Lowell

  ---

  --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

• gary1

  SSC-Insane

  Points: 21152

  More actions

  May 21, 2013 at 9:41 pm

  #1617249

  Thanks a lot!