I want to see if there is a way to get total space used per column on a table in sybase IQ.
I know a command "sp_iqdbspaceinfo" but this only returns the overall space used for all the columns in the tables.
I don't know whether this applies to Sybase IQ, however SQL Anywhere has a sa_column_stats() system procedure that may be of help here. Note: It does not really tell the space used but it may give some clues to the size of each column's data.
However, as SQL Anywhere does use a row-based storage and IQ does not AFAIK, it may not be appropriate here.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.