You are working on a database for an e-commerce website with millions of product listings. Customers frequently search for products using various criteria like price, category, and brand. What type of indexing strategy would you recommend to optimize search queries?

  • B-Tree Index
  • Bitmap Index
  • Full-Text Index
  • Hash Index
A B-Tree index is suitable for range queries, like searching products based on price, category, or brand, providing efficient retrieval of data based on range conditions. It organizes data in a hierarchical structure, making it ideal for search operations on large datasets.
Add your answer
Loading...

Leave a comment

Your email address will not be published. Required fields are marked *