Details
-
New Feature
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
None
-
None
-
2016-21, 2016-22, 2016-23
Description
There should be a means to determine storage actually used by columnstore by:
- all
- schema
- schema and table
This should report by:
- schema
- tablename,
- columnName
- dataType
- columnWidth
- dbroot
- partition
- segment
- filename
-size (in GB compressed). - Uncompressed size would be desirable if possible too.
Information_Schema tables (Table and Column etc) likely would be the best and standard ways to support this, but not all of this information may be representable in that form. What can be populated in infoschema should be done and then we can review an approach for most easily capturing the remaining attributes as either a proc, script, or mcsadmin command.
Attachments
Issue Links
- relates to
-
MCOL-406 Stored procedures required for I_S tables
- Closed