Re: Sorting Table

On Wed, 5 Aug 1998, Prasanna Athawale wrote: >Is there a way to sort a table on a key without unloading the >data from the table and store the sorted data back into the same >table??, thank U. Assuming there is an index on the key, then yes: ALTER INDEX indexname TO CLUSTER; If it is already clustered, do "ALTER INDEX indexname TO NOT CLUSTER" first. Yours, Jonathan Leffler (jleffler@informix.com) #include <witticism.h> Guardian of DBD::Informix v0.59 -- http://www.perl.com/CPAN Informix IDN for D4GL & Linux -- http://www.informix.com/idn