Toad World® Forums

Create inxed using alter table

I would like to ask for option making possible to generate index into DDL by using ALTER TABLE ADD INDEX syntax.

Current one (CREATE INDEX) requires INDEX privilege and often fails on shared hosting machines. Adding index using alter syntax requires only ALTER privilege which is usually available.

In any way, such option would be useful at least to me :wink:

Hi Michal,

thank you for your suggestion. Please add it to the Idea Pond at

Thank you!


I started to ‘flood’ Idea Pond system with ideas. Looks I’m almost the first one.
Is there any way to further track ideas? if one has been accepted, is under development, when release is scheduled etc.