Please help me with the following performance issue:
I have two views; Each of them combines about 5 large tables and returns
about 15 columns. Each view is already used by some part of my system.
I need to retrieve some of this data for a new component.
I wonder whether it would be acceptable design to build new view that
combine these two views, retrieving only 5 columns from the 30 columns
From Performance aspect, will I do better if I create the view from scratch,
or SQL is smart enough to not ask for redundant tables and data?
Thanks in advanced,