Hello All,

I am looking for some general advice concerning views vs. tables.  I have several processes for which I have created multiple views.  In other words, View 2 depends on View1 and so on.  Some of these are nested 6-8 deep.

I had some initial difficulty with unexpected join results (SQL choosing a different join than what I coded?) but eventually got around that issue.  Now I am questioning my performance.

Is this a poor practice (nested views)?  Can nested views in fact alter the execution plan from what I specified? Should I be using tables?  Should I be nesting my select statements into one or two large stored procedures?

Any advice would be appreciated.

Sincerely,
Lonnie Meinke