Re:Ask HN: What problem in your industry is a potential star...
by knodi123 on Tuesday June 30, 2015 @02:54PM
(#9807617)
Thanks for the tip. I'm not so worried about insert/update, since this is a reporting database and the only inserts are done by backgrounded processes.
Yes, we have fk indexes.
I don't see how we can filter down the number of rows, since the purpose of the outer query is to get a count of how many buyclicks there were for each offer. But I'll see if I can create a covering index that reduces the join cost.
Yes, we have fk indexes.
I don't see how we can filter down the number of rows, since the purpose of the outer query is to get a count of how many buyclicks there were for each offer. But I'll see if I can create a covering index that reduces the join cost.
Thanks again!