So Never think It'll be inefficient since the database could surprise you - look at the produced question plan. A notable exception could well be When the view has a gaggle BY clause that affects the output - where scenario You could not do the WHERE in the 'exterior'. This https://chancerbjyc.gynoblog.com/38402429/considerations-to-know-about-business-solutions