ch09 index.sql

来自「以Microsoft SQL Server为代表的数据库产品具有超大容量的数据存」· SQL 代码 · 共 67 行

  
DROP INDEX books.ind_books_ISBN


USE ElecTravelCom
CREATE UNIQUE CLUSTERED INDEX ind_books_ISBN
ON books(ISBN)





USE ElecTravelCom
CREATE UNIQUE NONCLUSTERED INDEX ind_books_title
ON books(title)


DROP INDEX books.ind_books_title


USE ElecTravelCom
CREATE UNIQUE NONCLUSTERED INDEX ind_books_title
ON books(title)
INCLUDE (pressName)





USE ElecTravelCom
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
DECLARE @db_id INT
DECLARE @object_id INT
SET @db_id = DB_ID(N'AdventureWorks')
SET @object_id = OBJECT_ID(N'AdventureWorks')
SELECT *
FROM sys.dm_db_index_physical_stats(@db_id, @object_id, NULL, NULL, 'DETAILED')




USE AdventureWorks
UPDATE STATISTICS Production.Product