| calculation [message #50736] |
Wed, 03 April 2002 22:31  |
krishna
Messages: 141
Registered: October 1998
|
Senior Member |
|
|
Given the number of initial rows in a table, and also the datatypes of the different columns in that table, what is the formula for finding out how many rows can be accomodated in a data block?
Please help, it's urgent!
|
|
|
|
| Re: calculation [message #51200 is a reply to message #50736] |
Tue, 07 May 2002 01:24  |
Sreedhar
Messages: 30
Registered: March 2000
|
Member |
|
|
Hi Krishna..
Check out this procedure.. for the Table size;
1)7292/<rowsize> == number of rows per block
2)number of rows per block * total number of rows to proces = size in bytes
3)size in bytes /1024/1024== size in megss
Let me know if u need more info...
Thanks
-Sreedhar
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
