Information générale
Catégorie:
Codage, syntaxe et commandes
>>>>Is there a way to index a view so I can do a seek?
>>>
>>>Trish, just SELECT you view and index it as if it is a table.
>>
>>But I have to write to to it and want to use the buffering. Plus, if we upgrade to SQL server we have been trying to just use views.
>
>You stil wil be able to update the indexed view, and you are just limited to use only row buffering for your view. For indexing purpose it doesn't matter which view you are using -local or remote.
I can't use table buffering?
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement