[dicipulofer]

How can I rebuild one index for one table ?


well, how I know what are the index of one table ?????

[ceinma]

>>>> well, how I know what are the index of one table ?????
answer:
option 1) dbschema -d <you_database> -t <your_table> -ss
option 2) open a connection with your database and write a SQL with tables "systables" and "sysindexes" or "sysindices"


>>>> How can I rebuild one index for one table ?

option 1) drop index...; create index...
option 2) set indexes <idx_name> disabled; set indexes <idx_name> enabled

[anurbas]

Another option is:

ALTER FRAGMENT ON INDEX <index_name>;

If you want to place this in a new dbspace:

ALTER FRAGMENT ON INDEX ixshipdeta2 <index_name> in <dbspace_name>;