size category while creating a ztable

[kiran_k8]

Hi,

I had created a ZTABLE with Size category(Technical Settings) as 1 which has a capacity of 1,400 to ,5700.

Just in case at a later date if the no.fo records gets increased will the system take care of the size category by itself

or it has to be changed again.

Thanks,

K.Kiran

[kiran_k8]

if you know that this may be increased, better define it as a greater value range.

but any ways.

The size category determines the probable space requirement for a table in the database.

You can select the categories 0 to 4 for your table. Each category is assigned a specific fixed storage area value in the database. 
When you create a table, initial space is saved for it in the database. If more space is required later as a result of data that has been 
entered, the storage space is increased in accordance with the category selected.

[Former Member]

if you know that this may be increased, better define it as a greater value range.

but any ways.

The size category determines the probable space requirement for a table in the database.

You can select the categories 0 to 4 for your table. Each category is assigned a specific fixed storage area value in the database. 
When you create a table, initial space is saved for it in the database. If more space is required later as a result of data that has been 
entered, the storage space is increased in accordance with the category selected.

[Former Member]

Hi,

System will take the care of table size as soon we add more recors in table.

Thanks,

[Former Member]

Hi Kiran,

Your current settings will work. But it is always good to know the approximately no of records from functional consultant so that we can give appropriate size category.

Thanks & Regards,

Anil Salekar

[Former Member]

@ soumya..

had a question.

why do we need four different categories if system adjusts the table sizes itself. Is there any specific reason?

Regards,

Sumit Nene.

[Former Member]

Okay this is how it works

suppose size category 0 indicated 1 to 100 records. Now as soon as ur table reaches the 101th record anothe 1 to 100 records will be allocated to the tablespace of this table, thereby wasting table space. If you plan ahead this wastage can be avoided.

[Former Member]

@Sumit.

see. when you declare a size category the system saves that much space as default for the data base. and each time mroe records come it increases the size by that size category value.

when we know that there can be HUGE data coming to the DB for that table we define it as larger category from the beginning which wont be needing adjustments in underlying database.

got my point?