Indexing in Sql Server 2014

Indexing of a table in SQL server usually means a look up table

#Clustered Indexing

Primary key

#NonCluster Indexing
CREATE NONCLUSTERED INDEX ix_TV_ProductReceive ON [TV].[ProductReceive] (ID DESC, JobID DESC,ServicePointID);

CREATE NONCLUSTERED INDEX ix_TV_ProductService ON [TV].[ProductService] (ProductServiceId DESC);

CREATE NONCLUSTERED INDEX ix_TV_SparePartsRequision ON [TV].[SparePartsRequision] (ProductServiceId DESC);


DROP INDEX ix_Questions on Questions.Questions

Posted in sql

Leave a Reply

Your email address will not be published. Required fields are marked *