I need SPEED!!

Several things can increase your speed, try these!







USE ProvidusDB
GO
CREATE NONCLUSTERED INDEX Idx_doc_id_entity_id ON dbo.task_inst_doc_results_by_ent 
(
	doc_id ASC,
	entity_id ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF) ON PRIMARY