Re: A Couple of Questions on Views

From: Tony <andrewst_at_onetel.net.uk>
Date: 3 Mar 2004 05:46:39 -0800
Message-ID: <c0e3f26e.0403030546.581db5e2@posting.google.com>

deeplfo_at_yahoo.com (MG) wrote in message news:<c8e3e11c.0403022058.5da2129d_at_posting.google.com>...
> 1) Can stored procedures be used against views?

Yes

> 2) What are the main limitation or disadvantages of using views?

None, as long as you use common sense. For example, if you have a view based on the dept table with lots of joins to other tables, aggregate functions, calls to user-defined functions, etc. then it would be inadvisable to use it in a query like "select dname from my_view" if all you really needed was "select dname from dept". Received on Wed Mar 03 2004 - 07:46:39 CST