You can index on the table even though it is open with another user by using the syntax "index on myfield to myindex compact". This creates an old style idx type index which you can minipulate to your heart's desire. You must then use the command "set index ot myindex". After you are finished with your index be sure to "delete fiel myindex.idx" after closing the table. Be sure to include the 'compact' keyword , otherwise the index will be 3-5 times larger in size.