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.
