> What do you mean on-the-fly? I mean at run-time ,after you have the data in the client > I tried to index the view, but I got an error "Command cannot be issued on > a table with cursors in table buffering mode" set buffering off -create the index and set it back on