Re:Modularizing SQL? (2007)
by nightski on Thursday June 18, 2020 @03:11PM
(#23566568)
Sure they are, you just slap a where statement on your query when you query a view. Or am I missing something?
[ Parent
| on HN ]
Sure, that's sufficient most of the time. However, there times when your view might span multiple tables and you want to ensure that full table scans aren't triggered before your view predicate is acted upon.
This may also come down to how sophisticated your DBs sql optimizer is.