How do you check if an index has been sucessfully created?
For example under mysql:

mysql > alter table TABLE_A add index (Field1);

is successful?

because using "describe" doesn't seem to show
the effect of the changes.

--
Regards,
Edward

ewijaya wrote :

"mysql > show index from TABLE_A;"

For more complete informations, you could also try:

"mysql > show create table TABLE_A;"

--
Hugo