views vs stored queries

On Sun, 13 Dec 1998 14:52:46 GMT, tkyte_at_us.oracle.com (Thomas Kyte) wrote:

>views are not just stored queries. A view is much more like a database table
>then a stored query.

But aren't they implemented much like stored queries? I mean you basically have a SELECT statement defining the view, and that statement is stored in the database. Right? And when you select from a view the optimizer makes some decisions about how to merge the stored SELECT (the view) with your SELECT against that view. Right?

I usually do tell people that a view is just a stored query, in part because people do get some funny ideas about how they are implemented. I've even had people think that a view's query was executed at view creation time, creating the result set at that point.

regards,

Jonathan

p.s. I remember years ago trying to use ORDER BY in a view definition. Struck me as odd, at first, that I couldn't. After thinking about it for awhile though, it makes perfect sense. Received on Sun Dec 13 1998 - 22:45:27 CST