Index creation - Disk space requirements
Hi,
I currently have a MyISAM table(ForecastArchive) with the following columns:
(latitude(float), longitude(float), issuedDate(datetime), value1(float),value2(float),value3(float))
The table is partitionated per month on column issuedDate.
The table data size is of 40 GB.
I want to create an index on (latitude, longitude) columns.
1) I would like to know which would be the resulting index file size?(estimation)
2) Which is the estimated required disk space to create the index?(maybe the engine require more than the final index size to perform the index creation, correct me if I am wrong)
If any can give me a hand on this, I would be grateful.
Thanks.
Esteban.
Subject
Views
Written By
Posted
Index creation - Disk space requirements
7307
January 12, 2010 03:05PM
3835
January 13, 2010 09:20PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.