Hi Team
This query takes more time than usual for execution
How to optimize it in best possible way
Columns used in this query >> composite index eventhough not running
optimally
SELECT EXISTS (SELECT Key FROM CACHEKEYS WHERE CacheType = $1 AND TrsId =
$2 AND BrandId = $3 AND SportId = $4 AND CompetitionId = $5 AND EventId =
$6 AND MarketId = $7 LIMIT ?)
Regards
Durga Mahesh