Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
CanadaDBA
583 Posts |
 Posted - 2005-04-15 : 13:53:35
|
| Is it creating the view whenever a script is referring to it? Or it maintain the view after first built up and then keeps it refresh?Env.: SQL2000 Enterprise & Windows 2003Canada DBA |
|
|
jason
Posting Yak Master
164 Posts |
Posted - 2005-04-15 : 14:14:18
|
| Non-indexed view are refreshed at run time. Indexed views are stored like tables. BOL - View Resolution. |
 |
|
|
|
|
|
How the SQL Server deals/handles the views?