Hi,
Wanted to know the size of a table on disk. Assume, I have a Table with 10 columns. Only, Varchar2, Number and Date Fields. For example, same data in CSV file with all fields occupying full data as that of it's VARCHAR2 field size and having 100,000 records occupy 100 MB on disk. In this case just wanted to know, does table also occupy same space on disk? If no, what's the approximate percentage of diviation?
If there are indexes defined on some 3 columns of the table, and field types for these 3 columns would be, Date field, a Number field and third field as Varchar2(100) field respectively. In this case, approximately how much extra disk space will be ustilized in percentage?
Please note, I am not interested about any other sizing like DB size, other schema size, software size, etc., etc., Just wanted to know, if I have a data of 1 GB in CSV file and I load it into Table, will it take equal amount of size on disk or there is major difference. Of course, I know that because of field width definision in Table, there will be major change in disk space utilization. However, for above estimate, just consider that, Varchar2 size of columns and actual data in CSV matches same.
Thanks,
-Anand