I suspect you're just working around an issue with the query or the DB itself. Previous company had to do something like that because of an Oracle perf bug way

I suspect you're just working around an issue with the query or the DB itself. Previous company had to do something like that because of an Oracle perf bug way back (outer join issue I believe?), but they fixed it eventually and it was all deleted.