Actually, in SQLServer 6.5 when you created a view and a user selected
against the view MS SQLServer did actually create a temporay table with all
the rows that defined the view and then executed the select against that.
One client I know made the mistake of using views and had to put the temp
device on a ram disk to get good performance. I hope they fixed that in SQL
Server 7.
Jim
--
Our new email address is kennedy-family_at_home.com
Have a happy Holiday.
"Michael Carton" <MikeC_at_erols.com> wrote in message
news:3A48DF6D.6922CBE7_at_erols.com...
> Barbara Kennedy wrote:
> >
> > No. think of a view as a predefined query that you can issue queries
> > against. I believe in SQL Server that views when they have queries
executed
> > against them create a temporary table and then the query is executed
against
> > that.
>
> That's not true. SQL Server views operate like Oracle views. The original
poster
> was looking for a SQL Server feature that's not present in Oracle (and he
was
> confused, to boot.)
>
> --
> MikeC
>
> Please reply to the group.
Received on Tue Dec 26 2000 - 20:04:14 CST
