on 11-21-2014 1:34 AM
I have some partitioned tables, and I need to identify the size of each partition, it is possible??
Best regards,
JC
Hi JC
As you may know, IQ doesn't have a procedure of supplying a partition's size even in IQ 16.0.
Procedures related to object's size are sp_iqdbsize, sp_iqtablesize and sp_iqindexsize.
Of course, I think we can estimate the rough size of a specific partition using its condition, satisfying rows and its data type.
But, it might become rather complicated in implementing the requirement.
I'm not sure there exists a specific argument for calculating the partition size using 'iq utilties' command.
Best Regards
Jerry
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
81 | |
25 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.