Re: alter index

On 28 Jul 98 at 11:33, Sadagopan, Sathish wrote: > Is Alter index to cluster a good idea to force contiguity and free > up space than doing a dbexport/dbimport , what are the pros and cons ALTER INDEX is probably quicker and simpler, particularly if you wantto only process one table. Dbexport/dbimport is better if you want to process the entire database, plus *all* your indexes will be contiguous as well. Remember to take a full level 0 archive before you start buggering around... :-) HTH. -- Ciao, Billy /Group Managing Director, The West Solutions Group: http://www.west.co.za \\ Drivel @ http://www.west.co.za/tasteless/ / \\ "Granted, Mr Wheeler's ideas are stupid and unreasonable, but he does own the company and I / think we should go along with him..." \\________________________________________________________________________________________________