And yes, this occasionally means that adding a where id in (select id from company) sometimes will switch your query from doing a full table scan to using

And yes, this occasionally means that adding a where id in (select id from company) sometimes will switch your query from doing a full table scan to using an index, fixing your problem for long enough to prepare a fix to add the appropriate index. Not that I've ever had to do something like that or anything.