Đang chuẩn bị nút TẢI XUỐNG, xin hãy chờ
Tải xuống
The Real MTCS SQL Server 2008 Exam 70/432 Prep Kit- P130: Congratulations on your journey to become certified in SQL Server 2008. This book will help prepare you for your exam and give you a practical view of working with SQL Server 2008. | Implementing Objects Chapter 14 627 Table 14.2 Index Options Option Explanation PAD_INDEX ON 1 OFF When this option is ON free space is allocated in each page of the index. Allows for new values to be inserted without rearranging a large amount of data. The amount of free space allocated is specified by the FILLFACTOR parameter. When this option is OFF enough free space for one row is reserved in every page during index creation. FILLFACTOR fill factor Specifies the percentage of each page that percentage should be filled up with data. For example a fill factor of 80 means 20 of each page will be empty and available for new data. The fill factor is used only when you create or rebuild an index. Fill factor and index padding are discussed in detail in Chapter 7. SORT_IN_TEMPDB ON 1 OFF Specifies whether the data should be sorted in the tempdb database instead of the current database. This may give performance advantages if the tempdb database is stored on a different disk to the current database. IGNORE_DUP_KEY ON 1 OFF Specifies that duplication errors should be ignored when creating unique indexes. STATISTICS_NORECOMPUTE Specifies that optimization statistics should ON 1 OFF not be updated at this time. DROP_EXISTING ON 1 OFF Specifies that the existing index with the same name should be dropped and then be re-created. This equates to an index rebuild. ONLINE ON 1 OFF Specifies that the underlying table should remain online and accessible by users while the index is being built. This option is only available in SQL Server 2008 Enterprise or Developer edition. ALLOW_ROW_LOCKS Specifies whether locks should be held on ON 1 OFF each row as necessary. ALLOW_PAGE_LOCKS Specifies whether locks should be held on ON 1 OFF each page as necessary. Continued 628 Chapter 14 Implementing Objects Table 14.2 Continued. Index Options Option Explanation MAXDOP max_degree_ of_parallelism Specifies the maximum number of processors that are to be used during the rebuild operation. .
