a) INDEX: The “INDEX” is used to improve or increase the performance of the queries. It speeds up “SELCET” queries and “WHERE” clauses. In order to create an index it uses the “CREATE INDEX” statement in which one can specify the name of the index, specify the name of the table and the name of the columns. Syntax for creating index: CREATE INDEX name_of_index ON table_name;

BuyFind

A Guide to SQL

9th Edition
Philip J. Pratt
Publisher: Course Technology Ptr
ISBN: 9781111527273
Chapter 7, Problem 6TD
Program Plan Intro

a)

INDEX:

The “INDEX” is used to improve or increase the performance of the queries.

  • It speeds up “SELCET” queries and “WHERE” clauses.
  • In order to create an index it uses the “CREATE INDEX” statement in which one can specify the name of the index, specify the name of the table and the name of the columns.

Syntax for creating index:

CREATE INDEX name_of_index ON table_name;

Explanation of Solution

 b)

 Query to create index on “ITEM” table:

CREATE INDEX ITEM_INDEX2 ON ITEM(CATEGORY);

Ex...

Explanation of Solution

 c)

 Query to create index on “ITEM” table:

CREATE INDEX ITEM_INDEX3 ON ITEM(CATEGORY, STOREHOUSE);

Explanation...

Explanation of Solution

 d)

Query to create index for table “ITEM”:

CREATE INDEX ITEM_INDEX4 ON ITEM(CATEGORY DESC, STOREHOUSE);

Explanation:

The above query is used to c...

Want to see the full answer?

Check out a sample textbook solution.

Want to see this answer and more?

Experts are waiting 24/7 to provide step-by-step solutions in as fast as 30 minutes!*

*Response times may vary by subject and question complexity. Median response time is 34 minutes for paid subscribers and may be longer for promotional offers.