fragmentation

Hi: It wanted to know that type of fragmentation is but the optimal one: 1. Using line of commandos 2. Recreating totally the table And it wanted to know as of of these two types of fragmentation he is but the optimal one: example1: Begin work; set lock mode to not wait;lock table tabla_ejemplo1 in exclusive mode; alter index idx_campo1 to cluster; alter index idx_campo1 to not cluster;commit work: example2: Begin work; set lock mode to not wait;lock table tabla_ejemplo2 in exclusive mode; alter fragment on table tabla_ejemplo2 init fragment by round robin in dbspacesA, dbspacesN;-- index clustering will not be performed because above statement -- will re-organize table's data as side effect commit work; thank you very much _________________________________________________________________ Las mejores tiendas, los precios mas bajos, entregas en todo el mundo, YupiMSN Compras: http://latam.msn.com/compras/ sending to informix-list