USE School
IF EXISTS (SELECT name FROM sysindexes WHERE name = 'cs_cid_ind')
DROP INDEX CHOICES.cs_cid_ind
GO
SET STATISTICS IO ON
GO
SET STATISTICS TIME ON
GO
SELECT COUNT(*)
FROM CHOICES
WHERE cid=10040
GO