exporting/importing table from IDS 9.40

I was told that to improve performance sometimes is a good idea to export and import a table instead of sizing it (it's easier I've been told) How do I export/import table in IDS 9.40? (table not database) Thanks

Gentian Hila wrote: > I was told that to improve performance sometimes is a good idea to > export and import a table instead of sizing it (it's easier I've been > told) > > How do I export/import table in IDS 9.40? (table not database) > > Thanks Look for 'unload' and 'load' . Other possibilities include 'dbload' to load larger tables. In general look if the table is fragmented, do you have correct indexes, are any of them designated as 'cluster'. The simple idea of: unload, drop table, create table, load works well if you have space and can afford downtime. HTH Michael