Disadvantages of selecting higher than required data class & size category

[Former Member]

Hi !

What are the disadvantages of defining a table with a very much higher data class and size category of the really needed??

In fact, the table already exists has some data. All have size category 0, but because of the contents, they should have 2 or 3. Can we just put 9 and forget about it? how much space will be reserved in the database for those over defined tables? that could be wasted...

We are using ORACLE 10.

Thanks !

Matias

[Former Member]

Hi Matias,

The space will not be wasted. Lets say my table size is increased and there is not enough space left then the data size of the table whose category 9 is defined bt don't have much data space will be alocated to my table.

It is a best practise as always put size category as 0 for your Z tables SAP will automatically increase the space as the DB size increases.

Reward points if useful.

Regards,

Atish

[KKilhavn]

Hmmm... why is this best practice? I would have thought the best practice was to give your best estimate? The size will be automatically increased anyway, but by specifying the expected size the DB software can plan ahead and reserve some space to reduce (or delay) the fragmentation that will otherwise occur when the table needs more space.