What is index intersection strategy?

Index intersection combines multiple indexes to satisfy a query.

Instead of using one composite index, the optimizer can intersect results from multiple single-column indexes. This improves flexibility but may be slower than a well-designed composite index due to merging overhead.