syber
msg:4105720 | 2:54 pm on Mar 27, 2010 (gmt 0) |
VIEWS are not temp tables, they are stored SELECT statements. Think of them as virtual tables.
When you reference a view, the stored select statement is executed. Views allow you to create complex queries that you can treat as a table. The underlying data remains in the tables referenced in the view definition. Indexes for those tables are still utilized.
|
Sandro87
msg:4106407 | 2:41 pm on Mar 29, 2010 (gmt 0) |
what happens if 2 users run the same script at the same time? The view will be overwritten?
|
syber
msg:4106975 | 2:08 pm on Mar 30, 2010 (gmt 0) |
The view does not store any data. The two users see the same result set as if they had typed in the query directly.
|
bizminder
msg:4111271 | 9:19 am on Apr 7, 2010 (gmt 0) |
However with exclusive locks two users will never be able to run the same script simultaneously.
|
syber
msg:4111305 | 10:57 am on Apr 7, 2010 (gmt 0) |
SELECT statements don't acquire exclusive locks.
|
|
