topic Re: Increasing table size by adding fields in Application Development and Automation Discussions

Increasing table size by adding fields

Former Member — Thu, 11 Oct 2007 07:35:22 GMT

Hi,

Could anyone let me know to what extend we can increase the size of table.

Is there any impact on the database ?

If so then till what size we can safely increase our table size ?

Regards,

Imran

Re: Increasing table size by adding fields

Former Member — Thu, 11 Oct 2007 08:31:46 GMT

Hi,

I think we can add as many field we want to have in a data base tables . As such there is no impact on the database except the size that the table occupies . Programitically the impact can be reduced by proper indexing , sorting , binary search while selecting the data base record .

More over the performance in case of z* tables can be raised by selecting proper delivery class for the table in delivery&maintainence tab in se11.

Moreover putting right technical details for the z* table will also enhance the performance & reduce load on database during runtime execution.

Reward points if it helps u in some way... Hope i am clear..

Re: Increasing table size by adding fields

Former Member — Thu, 11 Oct 2007 08:40:06 GMT

hi,

in case of ztable you can add the fields

in pre-defined tables you have to include using INCLUDE...

Whenever you alter the table ... you have to generate the table maintenance generator.

regards

sree

Re: Increasing table size by adding fields

Former Member — Thu, 11 Oct 2007 08:57:22 GMT

Dear Frend,

U can increase table size by

se11~~>table name in database table tab~~>maintain~~>technical settings tab at top in standard toolbar~~>size category(here u can enter size as required by u).

It has an impact on all the programs,domains and data elements,etc using that table.It increase usage of database and affects program and table performance.

Basically size upto two options in size category is preferred(mostly first option).

Pls reward helpful points.

Regards,

Ameet