>Let me get this straight. I can switch to row buffering or even turn it off to build the index. Then set it to table buffering. Right before I do I seek, I change it to row buffering and when the seek if done, I can set it back to table buffering before I make any changes. This way, at the end of my processing, I can do a full tableupdate.
>
>Is this right?
Trish,

No, you cannot set the view to any buffering other than optimistic, you can change from table to row though. You only need to change the buffering to create the index, then set it back to table. You do not need to alter the buffering for your seeks at all.