So Will not believe It'll be inefficient because the database may well surprise you - consider the generated query approach. A notable exception would be Should the view has a gaggle BY clause that affects the output - where scenario you couldn't do the WHERE with the 'exterior'. Auto-propose will https://alexisrkbpc.blogoscience.com/46178017/5-simple-statements-about-view-details-explained