Getting 502 on join eloquent laravel
briley last edited by
I need to get distinct value using inner join. Here is query
SELECT distinct(ad_camp_sid.cid) from ad_camp_sid inner join ad_dsp_sites ON ad_dsp_sites.site_id = ad_camp_sid.sid where ad_dsp_sites.exchange = 4
table has records count as below: ad_camp_sid = 25602 ad_dsp_sites = 371173
Here ad_camp_sid.cid has thousands of records. I have added index on columns as well. Still its not responding. Can i user alternative or any solution for same.
Please suggest me.
Add these composite indexes:
ad_camp_sid: INDEX(sid, cid) ad_dsp_sites: INDEX(exchange, site_id)
When adding a composite index, DROP index(es) with the same leading columns. That is, when you have both INDEX(a) and INDEX(a,b), toss the former.