What does it mean when index scan does not show inItems and outItems, when query is picking up multiple indexes?

As you see here, middle Idx is showing in-out count.
Other 2 Indexes are not showing any such count?

If not showing means scan did not produced any items based on predicate spans on that index.
It looks like IntersectScan received 16 items. One of the IndexScan returns 16 others might taking longer and terminated (Rule based optimization, Intersect Scan is based on early termination, i.e. if one scan completes all the items produced by this indexscan are considered possible candidates and terminates other indexscans).

To avoid intersectscan provide hint via USE INDEX.

Also checkout How can an Intersect Scan return more items than MIN(inputs from respective indices). It's returning the MAX

1 Like

Thank You @vsr1 :+1: :+1: :+1: :+1: