General information
Category:
Coding, syntax & commands
>>>>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?
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only