7.3.3.sql

来自「清华大学出版社出版的数据库系统教程附带的实验教程中所有的源代码」· SQL 代码 · 共 12 行

USE School
IF EXISTS (SELECT name FROM sysindexes WHERE name = 'IX_sid')
DROP INDEX CHOICES.IX_sid
GO
CREATE CLUSTERED INDEX IX_sid ON CHOICES(SID)
GO
SET STATISTICS IO ON
GO
SET STATISTICS TIME ON
GO
select * from choices where sid like '800554358'
GO