How can I create an index for my query below.
FROM ResumeBucket as P
left join UserBucket U on U.
user.id = P.postJsonDto.user_id
WHERE 1 = 1
and ($userId in U.connections OR P.postJsonDto.user_id = $userId)
and P.postJsonDto.page_constant = ‘hp’
and ($userId not in P.hideUserIds OR P.hideUserIds is null)
order by P.postJsonDto.post_time desc
LIMIT 5 OFFSET $startPage