A

Admin • 802.91K Points
Coach

Q. Which index type is most appropriate for text searching that needs full-text search capability in MySQL?

  • (A) HASH
  • (B) BTREE
  • (C) FULLTEXT
  • (D) RTREE
  • Correct Answer - Option(C)
  • Views: 3
  • Filed under category MySQL
  • Hashtags:
Explanation by: Admin
FULLTEXT index is designed for full-text searches (MATCH...AGAINST) on text columns. BTREE is general-purpose for sorting and range queries. HASH is used by MEMORY engine for equality lookups. RTREE is for spatial indexes.

You must be Logged in to update hint/solution

Discusssion

Login to discuss.

Be the first to start discuss.