MSSQL Tutorial Index 20 codes

1 A statement that creates a nonclustered index based on two columns

2 A statement that deletes an index from the Billings table

3 Allow page and row locks

4 Allow User Table Access During Index Creation

5 Change an Existing Index with DROP_EXISTING

6 Control Parallel Plan Execution for Index Creation

7 Create a Composite Index

8 Create an index for the column emp_no of the table employee

9 Creating an Index on a Filegroup

10 Define Index Column Sort Direction

11 Disable an Index

12 Disable page and row locks Only table locks can be used

13 Disable page locks Table and row locks can still be used

14 DROP INDEX employee i_empno

15 Enforce Uniqueness on Non-Key Columns

16 Indexing a View

17 Intermediate Index Creation in Tempdb

18 The basic syntax of the CREATE INDEX statement

19 Use PAD_INDEX and FILLFACTOR

20 Using an Index INCLUDE