By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,882 Members | 2,453 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,882 IT Pros & Developers. It's quick & easy.

Performance of views accessed by multiple SPIDs?

P: n/a
I wonder if anyone has any hard fact based pro or contra, especially on
performance, about having views as opposed to tables when the object is
being accessed for read only by multiple sessions/users/spids. I am
particularly concerned about the multiple instantiations of the view.
Relevant thoughts on this are much appreciated.

Jul 23 '05 #1
Share this Question
Share on Google+
1 Reply

P: n/a
I don't think so. The SQL-DMO API does represent views, tables.. as
objects. But in normal context, views are not objects, they are not
instantiated or destroyed.

If you declare a view: create myView as select * from myTable;

The execution plans for the following are exactly the same, with no
abstraction/encapsulation overhead.
a) select * from myView;
b) select * from myTable;

Jul 23 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.