InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
A Column Is Having Many Repeated Values Which Type Of Index You Should Create On This Column, If You Have To? |
|
Answer» For example, assume there is a motor vehicle DATABASE with numerous low-cardinality COLUMNS such as car_color, car_make, car_model, and car_year. Each column contains less than 100 distinct values by themselves, and a b-tree INDEX would be fairly useless in a database of 20 MILLION vehicles. For example, assume there is a motor vehicle database with numerous low-cardinality columns such as car_color, car_make, car_model, and car_year. Each column contains less than 100 distinct values by themselves, and a b-tree index would be fairly useless in a database of 20 million vehicles. |
|