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

Reply via email to