-
I want to create some new tables and I understand that the estimate number of rows are as follows:
Table one 60
Table two 450
Table three 150
Table four 1000
Table five 500
Table six 200
Can any one please tell/show me exactly how to size the tables based on these above information?
still learning,
learn
-
If you want to size the tables based on the initial data load, then avg_row_len*# rows = size of table. I would suggest that, based on the growth rate of the table and the type of activity that the table(s) will undergo, that you size the tables accordingly.
-
Thanks for the answer. But my question is with the above information that I have supplied, how do I create a table with that Information.
Example for Table2 based on the information what number do I have to give initial extent, next extent, max extents, pct increase, pct used, pct free, etc.
syill learning,
learn
-
2 ways:
Hard: Read the Developer and Admin books the chapter Sizing.
Basically you estimate the max and avg row size and multiply.
Easy: In Schema Manager or DBA Studio simulate the creation of yor table and in Storage tab check Auto calculation , put your values, click "Show SQL" to view the generated SQL.
Hope it helps.
-
I really appreciate your help.
still learning,
learn
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|