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