Distribution in amps

Database
Enthusiast

Distribution in amps

Hi,

 In a system of 190 amps,Whenever I create a table 1 kb is assigned to each vproc by default summing to 190 kb. Why is this space assigned to each vproc. When I queried the allspace view, I am able to find this info.

Thanks,

yogi.

3 REPLIES
Enthusiast

Re: Distribution in amps

Hi

When you create a table, table header is created across all amps. It consumes 1024 B for that.

Thanks

Santanu

Enthusiast

Re: Distribution in amps

Thanks....

Senior Apprentice

Re: Distribution in amps

The table header is not always 1 KB, in fact it's usually larger, might be up to 1 MB per AMP

The actual size per AMP depends on the number of columns & indexes, multi value compression, etc.