How to gather table statistics

[maksim_senin]

Hi,

Sharing the best way I found for gathering statistics for a table, thanks to the Community!

Please find attached sample files, I hope there will be no issues to add other statistical functions like avg, stdev, etc., as well as change the load script to load from sources other then qvd.

That really help when you study new data source.

If someone has more advanced manner to gather statistics (e.g. for several tables at once), please feel free to sharing it also.

Best regards,

Maxim

[vardhancse]

Hi,

we can export memory statistics, Settings->Document Properties->Memory statistics(Button).

Export the .mem file into local system.

Open new QVW, load the .mem file with delimiter as <tab>.

now we can see the fields like-> Type, sub type, class, Avgcalctime, Bytes, CalcTime, count, and size.

we can use table box <object>->add required fields and we can see the table statistics

[maksim_senin]

Hi,

.mem file lets us to analyze information on data processing inside of QlikView and this is useful too of course. What I'm talking about is an manner to understand what data are by themself since you'll definitely need to decide whether it's necessary to truncate some field values or use autonumbered ID's instead of string.

Also using .mem file it is not possible to build some expression over table values (max, min, avg, whatever).

But it can be usefull to add memory statistics to table statistics. Will think about it.

Best regards,

Maxim