You have a table phone_book with 2 billion rows in it. Adding an index on last_name will require a lot of space. If the average last_name is 8 bytes long, you are looking at roughly 16 GB of space for the data portion of the index. Which of the following will help in reducing the size of index space?
Correct Answer: Indexing only the first 4 bytes
Explanation:
Note: This Question is unanswered, help us to find answer for this one
More LAMP MCQ Questions