>>>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.
Have you tried to index to an IDX
INDEX ON whatever TO delme.idx
I don't know how this works on SQL
Charles
Charles
"The code knows no master." - Chuck Mautz
"Everybody is ignorant, only on different subjects." - Will Rogers