Which condition is true about the use of the hash join algorithm?
发布于 2021-02-25 23:45:17
【单选题】 A The smallest of the tables in the join must fit in memory as set by join_buffer_size. B No index can be used for the join. C The query must access no more than two tables. D At least one of the tables in the join must have a hash index.
