...
- Create Streams to extract data from the internal PhixFlow tables.
- For each table that is part of a PhixFlow model, query the meta data table for its field types, and data size / disk requirements.
- In the case of varchar fields, take a statistically significent ramdom sample of actual data record fields to determine the average length of varchars stored.
- As an additional exercise, determine the number of records, the number of streams and the archive details for each stream.
See Also
...