THX , actually I did the test before I post the thread , But My DB is oracle7.3 , I am not sure how it works on oracle8 . I just wander that I heard the storage clause of old index will be reused in oracle8 . So is it possible for you to get it verified ?