Hi ,
Below is the existing query but when i run this for a single index with its fields i get the statistics data & count but when i am trying to run all these 4 -indexes and it's respective fields together i am not getting any Statistical table as output what changes do i need to make to list out all 4 indexes with their respective count in statistics. ..(For single index and it's fields it's working fine but when i try to merge all 4 index details it's statistics value is 0 as you can see below.)
You should use (index....) OR (index....) ... otherwise your logic could be wron as you have ORs and ANDs in your base query.
r. Ismo