Re: ROWID Question - functionality

It's a stretch, but you might consider the TO CLUSTER option for the index on the table you are working with. A lot of this info is found under the syntax guide for ALTER INDEX or CREATE INDEX. I'll just try to cover thekey points, since I'm sure y'all are capable of RTM. What happens is that TO CLUSTER cases a reordering of the rows in the physical table to agree with the order of your index. The entire file get rewritten; however, sufficient disk space is required to *MAINTAIN* (my emphasis) two copies of the table. This might possibly be a solution to your situation, but I must caveate that I'm not really sure, as I've never used this capability, nor do I know anyone that has. Good Luck! Harry Caughey Programmer/Analyst Automation Consultants, Inc. http://www.teamaci.com