Know the view-decomposition
If you do know enough to
Understand how to write the query direct to the base tables…
Why don’t you!?!
(Yes, there are reasons, but have a reason.)