logo

Crowdly

Browser

Add to Chrome

An e-commerce platform handles product search queries. Each search filters on ca...

✅ The verified answer to this question is available below. Our community-reviewed solutions help you understand the material better.

An e-commerce platform handles product search queries. Each search filters on category, price range, and brand. Currently, the database has a separate index on each filter column. The database retrieves matching row IDs from each index and intersects the results, examining approximately 25,000 rows per query. A proposed change creates a single combined index on (category, price_range, brand), narrowing to approximately 800 rows per query in a single traversal. Why does the combined index produce fewer rows examined?

More questions like this

Want instant access to all verified answers on moodle.polytechnic.bh?

Get Unlimited Answers To Exam Questions - Install Crowdly Extension Now!

Browser

Add to Chrome