Assume that the table BOOKS in a database with the primary key on Book ID has more than 25,000 records. A query is frequently executed in which the Publisher of the book appears in the WHERE clause. The Publisher field has more than 100 different values, and length of this field is quite long. Using the guidelines provided in the
Chapter 8, Review question #57
Assume that the table BOOKS in a database with the primary key on Book ID has more than 25,000 records. A query is frequently executed in which the Publisher of the book appears in the WHERE clause. The Publisher field has more than 100 different values, and length of this field is quite long. Using the guidelines provided in the text, suggest how you will assign an index for such a scenario.
This problem has been solved!
Do you need an answer to a question different from the above? Ask your question!
Answer
I would assign an index for such a scenario by considering the following guideli…View the full answer
Related Book For 
Modern Database Management
13th Edition
Authors: Heikki Topi, Jeffrey A Hoffer, Ramesh Venkataraman
ISBN: 9780134773650