object sizing

[Roshan]

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
"

[ErmanArslansOracleBlog]

You can use explain plan to get an estimated index size for a table.

Please see -> https://richardfoote.wordpress.com/category/estimate-index-size

[Roshan]

This doc is also helpful

How to Estimate the Size of Tables and Indexes Before Being Created and Populated in the Database? (Doc ID 1585326.1)

[ErmanArslansOracleBlog]

Yes indeed.