6.3.1.sql

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

USE School
GO

SET STATISTICS IO ON
GO

SELECT * FROM STUDENTS WHERE sname = 'gfxrgs'
GO

SELECT * FROM STUDENTS WHERE sname = 'gfxrgs'
GO

CREATE INDEX student_name ON STUDENTS (sname)
SELECT * FROM STUDENTS WHERE sname = 'gfxrgs'
DROP INDEX STUDENTS.student_name
GO

SET STATISTICS IO OFF
GO