InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
For a table having 4 columns, the number of columns to which hash function is applied when using hash indexes is __________(a) 1(b) 2(c) 3(d) 4 |
|
Answer» Right answer is (d) 4 To elaborate: In MySQL, for the hash indexes, a hash function is applied to each of the column values. The resulting hash values are stored in the index and used to perform lookups on it. |
|