Index

Hi all, Is it possible to drop and create an new index while there are users on the system and using that table? If yes, how ? Thanks in advance, Alex

I believe that dropping/creating an index requires an exclusive lock on the table. Therefore it is not possible to do this is if users have any locks on the table or rows in the table; and if you beat them to it, then they will not be able to access the table. I think you'd have to do this during a scheduled 'maintenance' period. "A. Bernaards" wrote: > Hi all, > > Is it possible to drop and create an new index while there are users on the > system and using that table? If yes, how ? > > Thanks in advance, > > Alex