Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Indexing Views Basic Question
Message
 
 
To
19/03/2005 09:41:32
General information
Forum:
Microsoft SQL Server
Category:
Database management
Miscellaneous
Thread ID:
00997575
Message ID:
00997653
Views:
14
>I read in a book that by indexing a view you made the data permenant.

That's correct. An Indexed view is stored in a database like a table.

>That doesn't make sense.

You cannot create an index on something that doesn't exist.

>Does the indexed view refresh its data each time it is selected?

No, it's updated every time underlying table is updated.
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform