ch08.sql

SQLServer2005基础教程,清华大学出版社

 
DROP INDEX books.ind_books_ISBN
USE ETravelCom
CREATE UNIQUE CLUSTERED INDEX ind_books_ISBN
ON books(ISBN)



USE ETravelCom
CREATE UNIQUE NONCLUSTERED INDEX ind_books_title
ON books(Title)
DROP INDEX books.ind_books_title


USE ETravelCom
CREATE UNIQUE NONCLUSTERED INDEX ind_books_title
ON books(Title)
INCLUDE (pressName)

USE ETravelCom
DROP INDEX ind_books_title
ON books
SELECT * FROM books

SELECT *
FROM sys.dm_db_index_operational_stats(NULL, NULL, NULL, NULL)


USE AdventureWorks
DBCC SHOW_STATISTICS('Production.Product', AK_Product_Name)
USE AdventureWorks
UPDATE STATISTICS Production.Product


USE ETravelCom
SELECT *
FROM books
WHERE Title = 'SQL Server简明教程' AND publicateDate = '2008-01-01'