Posted by Serge Rielau on 02/03/06 20:16

Doug wrote:
> Again, a mindset. Could someone help me with why you would prefer a
> view over a stored procedure? I can almost see the indexed views for
> the right application, but there has to be a lot of overhead to
> maintain that indexed view for large tables.
I think a core question is:
Do you believe in writing complex SQL (say a 5 way join...).
If you do, then why would you not want to macro-ize common combinations
of joins you do over and over again?
If you prefer very simple SQL, full control, and cursors then, by all
means.. views may not be for you.

Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
DB2 UDB for Linux, Unix, Windows
IBM Toronto Lab

[Back to original message]