At least one of the non-cluster indices must be unique, at least one of the indices must contain an additional included column (s).

computer science

Description

Assignment requirements

 

Create a MySQL script that does the following:

 

Create table (s) with the following indexes:

• cluster index;

• non-cluster index;

• composite index;

• filtered index.

 

At least one of the non-cluster indices must be unique, at least one of the indices must contain an additional included column (s).

 

Creates a table with a computed column with an index on that column.

 

Find created indexes in Object Explorer.

 

Fill in the tables with the data.

 

Write queries with conditions that use each of the created indexes (do not use "hints").

 

Check the use of the index with the Execution Plan.


Delete tables.


Related Questions in computer science category