#DateWhereItemComment
728 Jan 2014 @ 06:45 PSTr.sagner's blogColumn compress values from statisticsHi Nishant, You are completely right. Only for the case that it would be good to compress only nulls and you want to write COMPRESS(NULL) the finding of the percentage of nulls makes sense. At the...
627 Jan 2014 @ 05:01 PSTr.sagner's blogColumn compress values from statisticsHi Nishant, The number of nulls is never in the Biased values. In the output there is always an extra line with "NumOfNulls" (AWK Script Line 15). If the percentage of Nulls is relevant,...
525 Dec 2013 @ 07:31 PSTr.sagner's blogColumn compress values from statisticsHi all, The first "Unfortunately": Unfortunately the data for the "show statistics values" command is stored in a blob called FieldStatistics in binary form to be easily read b...
423 Dec 2013 @ 04:59 PSTr.sagner's blogColumn compress values from statistics  Yes, you can reuse your algorithm for compression of columns. Only the typical time consuming "select col,count(*) from ..." at the beginning can be replaced by a millisecond oper...
319 Dec 2013 @ 01:14 PSTr.sagner's blogColumn compress values from statisticsThanks for the comment, on this position blog was not clear. What I want to say is that during the "alter table ... compress" statement it is not allowed to have statistics on the column ...
231 Aug 2010 @ 12:16 PDTToolsFastLoad's useful -r option when loading a very large number of rowsHi Thomas, Thanks for the very good article. Is this option introduced with 13.10? My HP-UX fastload version 13.0.0.5 don't know this option. Thanks, Roland
130 Aug 2010 @ 09:41 PDTToolsFastLoad's useful -r option when loading a very large number of rowsDear Thomas, Can you tell me the disadvantages of this option when loading small files? Thanks a lot BR Roland