USE School
IF NOT EXISTS (SELECT name FROM sysindexes WHERE name = 'ix_sid’)
CREATE INDEX ix_sid ON CHOICES(sid)
GO
IF NOT EXISTS (SELECT name FROM sysindexes WHERE name = 'ix_tid’)
CREATE INDEX ix_tid ON CHOICES(tid)
GO