10-11-2007 8:35 AM
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
10-11-2007 9:57 AM
Dear Frend,
U can increase table size by
<b>se11</b>><b>table name</b> in database table tab><b>maintain</b>><b>technical settings</b> tab at top in standard toolbar><b>size category</b>(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
10-11-2007 9:31 AM
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 <b>z* tables</b> can be raised by selecting proper <b>delivery class</b> for the table in <b>delivery&maintainence tab</b> 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..
10-11-2007 9:40 AM
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 <b>table maintenance generator.</b>
regards
sree
10-11-2007 9:57 AM
Dear Frend,
U can increase table size by
<b>se11</b>><b>table name</b> in database table tab><b>maintain</b>><b>technical settings</b> tab at top in standard toolbar><b>size category</b>(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