i use SMS to build Views, and then use the Views as datasets for reports.
here's my question...
if i build several views that reference tables... and then link the views together in another view... is that less efficient (performance wise) than only having 1 view.
to put it another way, is it less efficient to have a view reference other views rather than a table?
i've been reading up on how sql queries are processed, but i'm not sure whether my way of building datasets/views is bad in the sense of query efficiency.
Start Free Trial
