Need to create proper Index

[atom_yang]

@krishn

“#operator”: “PrimaryScan”, “index”: “InheritxPI”, “keyspace”: “Inheritx”, “namespace”: “default”,

@krishn

USE INDEX (Campaign_status_Created_user)

USE INDEX don’t works, because the query don’t match index : user
and

@krishn

SUM(CASE WHEN Campaign.Campaign.status=3 then 1 ELSE 0 END ) total_pending_campaigns,

you should also add Campaign.status into index if you want to use CoverIndex

maybe you can remove all your index, and redefine the index and try again.