cancel
Showing results for 
Search instead for 
Did you mean: 

Does exist any procedure to identify a table partition size?

0 Kudos

I have some partitioned tables, and I need to identify the size of each partition, it is possible??

Best regards,

JC

Accepted Solutions (0)

Answers (1)

Answers (1)

jong-kil_park
Participant
0 Kudos

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