Re: Physical sizing of tables

Under SE, you have the following options (at least) 1. CLUSTER INDEX. Create a cluster index (preferably by dropping and recreating an existing index. On completion, ALTER INDEX TO NOT CLUSTER. 2. ALTER the TABLE, increasing the size of some column. (Alter it back, later) 3. UNLOAD the data. Unload the schema, including all constraints on it (both ways). Drop and create the table. Load the data back. Caution : dbschema will NOT return FOREIGN KEY constraints of other tables on this one. Option 1 is probably the preferred method - you could gain a double benefit if the index you use clusters the data 'appropriately'. Rudy Fernandes In article <7fhmhr$ej4$1@reef.news.technocom.net>, "Robert Cunningham-Brown" <rcunning@itad.co.uk> wrote: > How can I reduce the physical size of a table having deleted a large number > of records from that table? I am using Informix SE V5 & ISQL V4.10. > > Any help appreciated. > > Thanks, > Rob. > > -----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own