Dump and Load simple question

[adamk84]

Hi Everyone,

We recently have done some D&L on our systems, and I know that there is a benefit with gaining storage space. But I was wondering is there any other gains to doing a D&L as far as performance boost in reading records from the newly reloaded tables?

Thanks,

 

[TomBascom]

Sequential reads are usually improved. Especially if they use the same index that you dumped with.

Other improvements can be dramatic -- but they depend a lot on what the condition of your db was prior to the d&l and what you did to the structure of the db before loading. For instance, if you had highly scattered type 1 storage areas with a small db block and you moved to large db blocks in well designed type 2 storage areas you /could/ see 5x or 10x improvements in response time across the board.