object sizing

Posted by Roshan on
URL: http://erman-arslan-s-oracle-forum.114.s1.nabble.com/object-sizing-tp6884.html

Hi Erman,

is there a way I can calculate the size of indexes from the source database for each table. I am following the guideline from
DWSizingIntroV2.pdf
Capture.PNG

Minimum storage requirements.

"For each index, the following information was used to calculate the space requirements for the
indices in the schema:
.. Index size per row of the table
.. Page size
.. Index page overhead
.. Rows per page
.. Including the page overhead
.. Free slots per page
.. Free space for future page additions
"