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);

and

GO
DROP INDEX ix_Questions on Questions.Questions
GO