Question

We continue with the Colonial Adventure Tours Case (Chapter 4) in this module. Your focus will be on objects that support the Colonial Adventure Tours database.

Create the following indexes: [Show the SQL Server code for each index]
A. Create an index named TripIndex1 on the trip name field in the trip table.
B. Create a unique index named Tripindex2 on the type field in the trip table.
C. Create an index named Tripindex3 on the type and season fields in the trip table and list the seasons in descending order.

Answer 1

If you have any doubts, please give me comment...

Syntax:

CREATE INDEX index_name ON table_name (column1, column2, ...); // duplicates are allowed

CREATE UNIQUE INDEX index_name ON table_name (column1, column2, ...); /// duplicates are not allowed

A. CREATE INDEX TripIndex1 ON TRIP(TRIP_NAME);

B. CREATE UNIQUE INDEX TripIndex2 ON TRIP(TYPE);

C. CREATE INDEX TripIndex3 ON TRIP(TYPE, SEASON);

SELECT SEASON FROM TRIP;