[dba-SQLServer] Re: Difference between views and queries

Robert L. Stewart rl_stewart at highstream.net
Thu Jun 10 12:09:15 CDT 2004


John,

Because views are run on the server side unlike queries.
And, they use a SQL statement like a query, but they do
not use a query.  The server can optimize them since they
are stored also.

Robert

At 12:00 PM 6/10/2004 -0500, you wrote:
>Date: Thu, 10 Jun 2004 12:33:22 -0400
>From: "jwcolby" <jwcolby at colbyconsulting.com>
>Subject: [dba-SQLServer] Difference between views and queries
>To: "SQLServer" <dba-sqlserver at databaseadvisors.com>
>Message-ID: <001c01c44f08$a5d922a0$7e01a8c0 at colbyws>
>Content-Type: text/plain;       charset="us-ascii"
>
>Can anyone explain the difference between a view and a query?  Views use a
>query, plus the view keyword.  I have a couple of books that I have read the
>chapter on Views, but I so far haven't managed to "get" why you wouldn't
>just use the query itself instead of turning it into a view.
>
>
>John W. Colby
>www.ColbyConsulting.com





More information about the dba-SQLServer mailing list