A

Admin • 833K Points
Coach

Q. 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

Explanation by: Admin

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.

You must be Logged in to update hint/solution

Discusssion

Login to discuss.

Be the first to start discuss.