Just to follow up, I decided to try it another way and tried to create a demand index on @cb and @cd. It also aborted. We then deleted all of the lockfiles, and were able to create the indexes. Is the scan selection problem a lockfile issue also? Should it be? Larry Jr