Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Indexing Views Basic Question
Message
 
 
À
19/03/2005 09:41:32
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Maintenance bases de données
Divers
Thread ID:
00997575
Message ID:
00997653
Vues:
13
>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--
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform