Determine the impact of CREATE-INDEX on a large file
I am new to Cache' MV but have extensive experience with other Pick flavors especially Unidata.
I need to determine the impact of adding several indexes to a large file with over 51,000,000 records.
On other systems, I could use FILE.STAT, ANALYZE.FILE and shell to the OS to determine how large the index file was.
None of those seem to be available in Cache' MV. Shelling to the OS just tells me the size of CACHE.DAT.
What is the best way to determine what the disk impact would be if I added an index (CREATE-INDEX) to a file?