|
|
|
 |
 |
Archives of the TeradataForumMessage Posted: Mon, 22 Oct 2007 @ 13:58:49 GMT
I have a solution using a matrix (the functions of the curves for each set of presence bits) 1 bit 1 value (plus null) , 2 bits 3 values, up to 8 bits for 255 values. I have included the code to populate the matrix in a denormalized form. It is a bit excessive since it is only practical to compress the number of values that can be represented by the presence bits, but it makes a nice graph. This is a quick and dirty, way to solve this problem most of the time. Again this will not be perfect in all circumstances, but it will work for the majority of them. You can try to estimate Blocksize ,number of blocks , and complicated estimations trying to perfect the equation, but it doesn't buy you much in my opinion. Here is some information so you can put into context the below code, without me having to paste my entire algorithm. Variables: Rank_NBR = rank of the compressible values from highest to lowest (1-255) by its frequency of occurrence. N_pct = number of occurrences for compressible value / number of rows in table csum_n_pct = the cumulative sum of the n_pct at each interval (1,3,7, 15 .. 255). Columnlength = number of bytes to store the value, derived from dbc.Columns. Here is some logic to solve the optimal number of values to compress before the point of diminishing returns. Visually this works if the number you come up with is above the line, you are saving space , below the line you are adding space because.
/***********************************************************/
Select
/*other code*/
, Columnlength
,rank() over( partition by A.DATABASENAME,A.TABLENAME,A.COLUMNNAME
Order by diff_n_pct desc) as compress_value_rank
FROM
(
/**other code**
,sum(n_pct) over(partition by a.DATABASENAME ,A.TABLENAME ,A.COLUMNNAME
order by A.RANK_NBR asc rows unbounded preceding) as
csum_n_pct
, (case
when A.RANK_NBR = 1
then Compress_1 - csum_n_PCT
when A.RANK_NBR = 3
then Compress_3 - csum_n_PCT
when A.RANK_NBR = 7
then Compress_7 - csum_n_PCT
when A.RANK_NBR = 15
then Compress_15 - csum_n_PCT
when A.RANK_NBR = 31
then Compress_31 - csum_n_PCT
when A.RANK_NBR = 63
then Compress_63 - csum_n_PCT
when A.RANK_NBR = 127
then Compress_127 - csum_n_PCT
when A.RANK_NBR = 255
then Compress_255 - csum_n_PCT
else NULL end) * -1
as diff_n_pct
/*Other code*/
) A
FROM my.table LEFT JOIN mv_compression.compress_MATRIX B
on A.COLUMNLENGTH = b.COLUMNLENGTH
Qualify compress_value_rank = 1;
/***********************************************************/
drop table mv_compression.compress_MATRIX;
create MULTISET table mv_compression.compress_MATRIX
(
ColumnLength smallint not null,
Compress_1 Decimal (14,10),
Compress_3 Decimal (14,10),
Compress_7 Decimal (14,10),
Compress_15 Decimal (14,10),
Compress_31 Decimal (14,10),
Compress_63 Decimal (14,10),
Compress_127 Decimal (14,10),
Compress_255 Decimal (14,10)
)
UNIQUE PRIMARY INDEX UPI_compress_MATRIX(ColumnLength);
/*
select distinct
'insert into mv_compression.compress_MATRIX
values('||trim(ColumnLength)||' , '||
Compress_1 ||' , '||
Compress_3 ||' , '||
Compress_7 ||' , '||
Compress_15 ||' , '||
Compress_31 ||' , '||
Compress_63 ||' , '||
Compress_127 ||' , '||
Compress_255 ||' ); '||
from mv_compression.compress_MATRIX ;
*/
delete from mv_compression.compress_MATRIX ;
insert into mv_compression.compress_MATRIX values(1 , .1250000000
, .2500000000 , .3750000000 , .5000000000 ,
.6250000000 , .7500000000 , .8750000000 , 1.0000000000 );
insert into mv_compression.compress_MATRIX values(10 ,
.0125000000 , .0250000000 , .0375000000 , .0500000000 ,
.0625000000 , .0750000000 , .0875000000 , .1000000000 );
insert into mv_compression.compress_MATRIX values(100 ,
.0012500000 , .0025000000 , .0037500000 , .0050000000 ,
.0062500000 , .0075000000 , .0087500000 , .0100000000 );
insert into mv_compression.compress_MATRIX values(101 ,
.0012376240 , .0024752480 , .0037128710 , .0049504950 ,
.0061881190 , .0074257430 , .0086633660 , .0099009900 );
insert into mv_compression.compress_MATRIX values(102 ,
.0012254900 , .0024509800 , .0036764710 , .0049019610 ,
.0061274510 , .0073529410 , .0085784310 , .0098039220 );
insert into mv_compression.compress_MATRIX values(103 ,
.0012135920 , .0024271840 , .0036407770 , .0048543690 ,
.0060679610 , .0072815530 , .0084951460 , .0097087380 );
insert into mv_compression.compress_MATRIX values(104 ,
.0012019230 , .0024038460 , .0036057690 , .0048076920 ,
.0060096150 , .0072115380 , .0084134620 , .0096153850 );
insert into mv_compression.compress_MATRIX values(105 ,
.0011904760 , .0023809520 , .0035714290 , .0047619050 ,
.0059523810 , .0071428570 , .0083333330 , .0095238100 );
insert into mv_compression.compress_MATRIX values(106 ,
.0011792450 , .0023584910 , .0035377360 , .0047169810 ,
.0058962260 , .0070754720 , .0082547170 , .0094339620 );
insert into mv_compression.compress_MATRIX values(107 ,
.0011682240 , .0023364490 , .0035046730 , .0046728970 ,
.0058411210 , .0070093460 , .0081775700 , .0093457940 );
insert into mv_compression.compress_MATRIX values(108 ,
.0011574070 , .0023148150 , .0034722220 , .0046296300 ,
.0057870370 , .0069444440 , .0081018520 , .0092592590 );
insert into mv_compression.compress_MATRIX values(109 ,
.0011467890 , .0022935780 , .0034403670 , .0045871560 ,
.0057339450 , .0068807340 , .0080275230 , .0091743120 );
insert into mv_compression.compress_MATRIX values(11 ,
.0113636360 , .0227272730 , .0340909090 , .0454545450 ,
.0568181820 , .0681818180 , .0795454550 , .0909090910 );
insert into mv_compression.compress_MATRIX values(110 ,
.0011363640 , .0022727270 , .0034090910 , .0045454550 ,
.0056818180 , .0068181820 , .0079545450 , .0090909090 );
insert into mv_compression.compress_MATRIX values(111 ,
.0011261260 , .0022522520 , .0033783780 , .0045045050 ,
.0056306310 , .0067567570 , .0078828830 , .0090090090 );
insert into mv_compression.compress_MATRIX values(112 ,
.0011160710 , .0022321430 , .0033482140 , .0044642860 ,
.0055803570 , .0066964290 , .0078125000 , .0089285710 );
insert into mv_compression.compress_MATRIX values(113 ,
.0011061950 , .0022123890 , .0033185840 , .0044247790 ,
.0055309730 , .0066371680 , .0077433630 , .0088495580 );
insert into mv_compression.compress_MATRIX values(114 ,
.0010964910 , .0021929820 , .0032894740 , .0043859650 ,
.0054824560 , .0065789470 , .0076754390 , .0087719300 );
insert into mv_compression.compress_MATRIX values(115 ,
.0010869570 , .0021739130 , .0032608700 , .0043478260 ,
.0054347830 , .0065217390 , .0076086960 , .0086956520 );
insert into mv_compression.compress_MATRIX values(116 ,
.0010775860 , .0021551720 , .0032327590 , .0043103450 ,
.0053879310 , .0064655170 , .0075431030 , .0086206900 );
insert into mv_compression.compress_MATRIX values(117 ,
.0010683760 , .0021367520 , .0032051280 , .0042735040 ,
.0053418800 , .0064102560 , .0074786320 , .0085470090 );
insert into mv_compression.compress_MATRIX values(118 ,
.0010593220 , .0021186440 , .0031779660 , .0042372880 ,
.0052966100 , .0063559320 , .0074152540 , .0084745760 );
insert into mv_compression.compress_MATRIX values(119 ,
.0010504200 , .0021008400 , .0031512610 , .0042016810 ,
.0052521010 , .0063025210 , .0073529410 , .0084033610 );
insert into mv_compression.compress_MATRIX values(12 ,
.0104166670 , .0208333330 , .0312500000 , .0416666670 ,
.0520833330 , .0625000000 , .0729166670 , .0833333330 );
insert into mv_compression.compress_MATRIX values(120 ,
.0010416670 , .0020833330 , .0031250000 , .0041666670 ,
.0052083330 , .0062500000 , .0072916670 , .0083333330 );
insert into mv_compression.compress_MATRIX values(121 ,
.0010330580 , .0020661160 , .0030991740 , .0041322310 ,
.0051652890 , .0061983470 , .0072314050 , .0082644630 );
insert into mv_compression.compress_MATRIX values(122 ,
.0010245900 , .0020491800 , .0030737700 , .0040983610 ,
.0051229510 , .0061475410 , .0071721310 , .0081967210 );
insert into mv_compression.compress_MATRIX values(123 ,
.0010162600 , .0020325200 , .0030487800 , .0040650410 ,
.0050813010 , .0060975610 , .0071138210 , .0081300810 );
insert into mv_compression.compress_MATRIX values(124 ,
.0010080650 , .0020161290 , .0030241940 , .0040322580 ,
.0050403230 , .0060483870 , .0070564520 , .0080645160 );
insert into mv_compression.compress_MATRIX values(125 ,
.0010000000 , .0020000000 , .0030000000 , .0040000000 ,
.0050000000 , .0060000000 , .0070000000 , .0080000000 );
insert into mv_compression.compress_MATRIX values(126 ,
.0009920630 , .0019841270 , .0029761900 , .0039682540 ,
.0049603170 , .0059523810 , .0069444440 , .0079365080 );
insert into mv_compression.compress_MATRIX values(127 ,
.0009842520 , .0019685040 , .0029527560 , .0039370080 ,
.0049212600 , .0059055120 , .0068897640 , .0078740160 );
insert into mv_compression.compress_MATRIX values(128 ,
.0009765630 , .0019531250 , .0029296880 , .0039062500 ,
.0048828130 , .0058593750 , .0068359380 , .0078125000 );
insert into mv_compression.compress_MATRIX values(129 ,
.0009689920 , .0019379840 , .0029069770 , .0038759690 ,
.0048449610 , .0058139530 , .0067829460 , .0077519380 );
insert into mv_compression.compress_MATRIX values(13 ,
.0096153850 , .0192307690 , .0288461540 , .0384615380 ,
.0480769230 , .0576923080 , .0673076920 , .0769230770 );
insert into mv_compression.compress_MATRIX values(130 ,
.0009615380 , .0019230770 , .0028846150 , .0038461540 ,
.0048076920 , .0057692310 , .0067307690 , .0076923080 );
insert into mv_compression.compress_MATRIX values(131 ,
.0009541980 , .0019083970 , .0028625950 , .0038167940 ,
.0047709920 , .0057251910 , .0066793890 , .0076335880 );
insert into mv_compression.compress_MATRIX values(132 ,
.0009469700 , .0018939390 , .0028409090 , .0037878790 ,
.0047348480 , .0056818180 , .0066287880 , .0075757580 );
insert into mv_compression.compress_MATRIX values(133 ,
.0009398500 , .0018796990 , .0028195490 , .0037593980 ,
.0046992480 , .0056390980 , .0065789470 , .0075187970 );
insert into mv_compression.compress_MATRIX values(134 ,
.0009328360 , .0018656720 , .0027985070 , .0037313430 ,
.0046641790 , .0055970150 , .0065298510 , .0074626870 );
insert into mv_compression.compress_MATRIX values(135 ,
.0009259260 , .0018518520 , .0027777780 , .0037037040 ,
.0046296300 , .0055555560 , .0064814810 , .0074074070 );
insert into mv_compression.compress_MATRIX values(136 ,
.0009191180 , .0018382350 , .0027573530 , .0036764710 ,
.0045955880 , .0055147060 , .0064338240 , .0073529410 );
insert into mv_compression.compress_MATRIX values(137 ,
.0009124090 , .0018248180 , .0027372260 , .0036496350 ,
.0045620440 , .0054744530 , .0063868610 , .0072992700 );
insert into mv_compression.compress_MATRIX values(138 ,
.0009057970 , .0018115940 , .0027173910 , .0036231880 ,
.0045289860 , .0054347830 , .0063405800 , .0072463770 );
insert into mv_compression.compress_MATRIX values(139 ,
.0008992810 , .0017985610 , .0026978420 , .0035971220 ,
.0044964030 , .0053956830 , .0062949640 , .0071942450 );
insert into mv_compression.compress_MATRIX values(14 ,
.0089285710 , .0178571430 , .0267857140 , .0357142860 ,
.0446428570 , .0535714290 , .0625000000 , .0714285710 );
insert into mv_compression.compress_MATRIX values(140 ,
.0008928570 , .0017857140 , .0026785710 , .0035714290 ,
.0044642860 , .0053571430 , .0062500000 , .0071428570 );
insert into mv_compression.compress_MATRIX values(141 ,
.0008865250 , .0017730500 , .0026595740 , .0035460990 ,
.0044326240 , .0053191490 , .0062056740 , .0070921990 );
insert into mv_compression.compress_MATRIX values(142 ,
.0008802820 , .0017605630 , .0026408450 , .0035211270 ,
.0044014080 , .0052816900 , .0061619720 , .0070422540 );
insert into mv_compression.compress_MATRIX values(143 ,
.0008741260 , .0017482520 , .0026223780 , .0034965030 ,
.0043706290 , .0052447550 , .0061188810 , .0069930070 );
insert into mv_compression.compress_MATRIX values(144 ,
.0008680560 , .0017361110 , .0026041670 , .0034722220 ,
.0043402780 , .0052083330 , .0060763890 , .0069444440 );
insert into mv_compression.compress_MATRIX values(145 ,
.0008620690 , .0017241380 , .0025862070 , .0034482760 ,
.0043103450 , .0051724140 , .0060344830 , .0068965520 );
insert into mv_compression.compress_MATRIX values(146 ,
.0008561640 , .0017123290 , .0025684930 , .0034246580 ,
.0042808220 , .0051369860 , .0059931510 , .0068493150 );
insert into mv_compression.compress_MATRIX values(147 ,
.0008503400 , .0017006800 , .0025510200 , .0034013610 ,
.0042517010 , .0051020410 , .0059523810 , .0068027210 );
insert into mv_compression.compress_MATRIX values(148 ,
.0008445950 , .0016891890 , .0025337840 , .0033783780 ,
.0042229730 , .0050675680 , .0059121620 , .0067567570 );
insert into mv_compression.compress_MATRIX values(149 ,
.0008389260 , .0016778520 , .0025167790 , .0033557050 ,
.0041946310 , .0050335570 , .0058724830 , .0067114090 );
insert into mv_compression.compress_MATRIX values(15 ,
.0083333330 , .0166666670 , .0250000000 , .0333333330 ,
.0416666670 , .0500000000 , .0583333330 , .0666666670 );
insert into mv_compression.compress_MATRIX values(150 ,
.0008333330 , .0016666670 , .0025000000 , .0033333330 ,
.0041666670 , .0050000000 , .0058333330 , .0066666670 );
insert into mv_compression.compress_MATRIX values(151 ,
.0008278150 , .0016556290 , .0024834440 , .0033112580 ,
.0041390730 , .0049668870 , .0057947020 , .0066225170 );
insert into mv_compression.compress_MATRIX values(152 ,
.0008223680 , .0016447370 , .0024671050 , .0032894740 ,
.0041118420 , .0049342110 , .0057565790 , .0065789470 );
insert into mv_compression.compress_MATRIX values(153 ,
.0008169930 , .0016339870 , .0024509800 , .0032679740 ,
.0040849670 , .0049019610 , .0057189540 , .0065359480 );
insert into mv_compression.compress_MATRIX values(154 ,
.0008116880 , .0016233770 , .0024350650 , .0032467530 ,
.0040584420 , .0048701300 , .0056818180 , .0064935060 );
insert into mv_compression.compress_MATRIX values(155 ,
.0008064520 , .0016129030 , .0024193550 , .0032258060 ,
.0040322580 , .0048387100 , .0056451610 , .0064516130 );
insert into mv_compression.compress_MATRIX values(156 ,
.0008012820 , .0016025640 , .0024038460 , .0032051280 ,
.0040064100 , .0048076920 , .0056089740 , .0064102560 );
insert into mv_compression.compress_MATRIX values(157 ,
.0007961780 , .0015923570 , .0023885350 , .0031847130 ,
.0039808920 , .0047770700 , .0055732480 , .0063694270 );
insert into mv_compression.compress_MATRIX values(158 ,
.0007911390 , .0015822780 , .0023734180 , .0031645570 ,
.0039556960 , .0047468350 , .0055379750 , .0063291140 );
insert into mv_compression.compress_MATRIX values(159 ,
.0007861640 , .0015723270 , .0023584910 , .0031446540 ,
.0039308180 , .0047169810 , .0055031450 , .0062893080 );
insert into mv_compression.compress_MATRIX values(16 ,
.0078125000 , .0156250000 , .0234375000 , .0312500000 ,
.0390625000 , .0468750000 , .0546875000 , .0625000000 );
insert into mv_compression.compress_MATRIX values(160 ,
.0007812500 , .0015625000 , .0023437500 , .0031250000 ,
.0039062500 , .0046875000 , .0054687500 , .0062500000 );
insert into mv_compression.compress_MATRIX values(161 ,
.0007763980 , .0015527950 , .0023291930 , .0031055900 ,
.0038819880 , .0046583850 , .0054347830 , .0062111800 );
insert into mv_compression.compress_MATRIX values(162 ,
.0007716050 , .0015432100 , .0023148150 , .0030864200 ,
.0038580250 , .0046296300 , .0054012350 , .0061728400 );
insert into mv_compression.compress_MATRIX values(163 ,
.0007668710 , .0015337420 , .0023006130 , .0030674850 ,
.0038343560 , .0046012270 , .0053680980 , .0061349690 );
insert into mv_compression.compress_MATRIX values(164 ,
.0007621950 , .0015243900 , .0022865850 , .0030487800 ,
.0038109760 , .0045731710 , .0053353660 , .0060975610 );
insert into mv_compression.compress_MATRIX values(165 ,
.0007575760 , .0015151520 , .0022727270 , .0030303030 ,
.0037878790 , .0045454550 , .0053030300 , .0060606060 );
insert into mv_compression.compress_MATRIX values(166 ,
.0007530120 , .0015060240 , .0022590360 , .0030120480 ,
.0037650600 , .0045180720 , .0052710840 , .0060240960 );
insert into mv_compression.compress_MATRIX values(167 ,
.0007485030 , .0014970060 , .0022455090 , .0029940120 ,
.0037425150 , .0044910180 , .0052395210 , .0059880240 );
insert into mv_compression.compress_MATRIX values(168 ,
.0007440480 , .0014880950 , .0022321430 , .0029761900 ,
.0037202380 , .0044642860 , .0052083330 , .0059523810 );
insert into mv_compression.compress_MATRIX values(169 ,
.0007396450 , .0014792900 , .0022189350 , .0029585800 ,
.0036982250 , .0044378700 , .0051775150 , .0059171600 );
insert into mv_compression.compress_MATRIX values(17 ,
.0073529410 , .0147058820 , .0220588240 , .0294117650 ,
.0367647060 , .0441176470 , .0514705880 , .0588235290 );
insert into mv_compression.compress_MATRIX values(170 ,
.0007352940 , .0014705880 , .0022058820 , .0029411760 ,
.0036764710 , .0044117650 , .0051470590 , .0058823530 );
insert into mv_compression.compress_MATRIX values(171 ,
.0007309940 , .0014619880 , .0021929820 , .0029239770 ,
.0036549710 , .0043859650 , .0051169590 , .0058479530 );
insert into mv_compression.compress_MATRIX values(172 ,
.0007267440 , .0014534880 , .0021802330 , .0029069770 ,
.0036337210 , .0043604650 , .0050872090 , .0058139530 );
insert into mv_compression.compress_MATRIX values(173 ,
.0007225430 , .0014450870 , .0021676300 , .0028901730 ,
.0036127170 , .0043352600 , .0050578030 , .0057803470 );
insert into mv_compression.compress_MATRIX values(174 ,
.0007183910 , .0014367820 , .0021551720 , .0028735630 ,
.0035919540 , .0043103450 , .0050287360 , .0057471260 );
insert into mv_compression.compress_MATRIX values(175 ,
.0007142860 , .0014285710 , .0021428570 , .0028571430 ,
.0035714290 , .0042857140 , .0050000000 , .0057142860 );
insert into mv_compression.compress_MATRIX values(176 ,
.0007102270 , .0014204550 , .0021306820 , .0028409090 ,
.0035511360 , .0042613640 , .0049715910 , .0056818180 );
insert into mv_compression.compress_MATRIX values(177 ,
.0007062150 , .0014124290 , .0021186440 , .0028248590 ,
.0035310730 , .0042372880 , .0049435030 , .0056497180 );
insert into mv_compression.compress_MATRIX values(178 ,
.0007022470 , .0014044940 , .0021067420 , .0028089890 ,
.0035112360 , .0042134830 , .0049157300 , .0056179780 );
insert into mv_compression.compress_MATRIX values(179 ,
.0006983240 , .0013966480 , .0020949720 , .0027932960 ,
.0034916200 , .0041899440 , .0048882680 , .0055865920 );
insert into mv_compression.compress_MATRIX values(18 ,
.0069444440 , .0138888890 , .0208333330 , .0277777780 ,
.0347222220 , .0416666670 , .0486111110 , .0555555560 );
insert into mv_compression.compress_MATRIX values(180 ,
.0006944440 , .0013888890 , .0020833330 , .0027777780 ,
.0034722220 , .0041666670 , .0048611110 , .0055555560 );
insert into mv_compression.compress_MATRIX values(181 ,
.0006906080 , .0013812150 , .0020718230 , .0027624310 ,
.0034530390 , .0041436460 , .0048342540 , .0055248620 );
insert into mv_compression.compress_MATRIX values(182 ,
.0006868130 , .0013736260 , .0020604400 , .0027472530 ,
.0034340660 , .0041208790 , .0048076920 , .0054945050 );
insert into mv_compression.compress_MATRIX values(183 ,
.0006830600 , .0013661200 , .0020491800 , .0027322400 ,
.0034153010 , .0040983610 , .0047814210 , .0054644810 );
insert into mv_compression.compress_MATRIX values(184 ,
.0006793480 , .0013586960 , .0020380430 , .0027173910 ,
.0033967390 , .0040760870 , .0047554350 , .0054347830 );
insert into mv_compression.compress_MATRIX values(185 ,
.0006756760 , .0013513510 , .0020270270 , .0027027030 ,
.0033783780 , .0040540540 , .0047297300 , .0054054050 );
insert into mv_compression.compress_MATRIX values(186 ,
.0006720430 , .0013440860 , .0020161290 , .0026881720 ,
.0033602150 , .0040322580 , .0047043010 , .0053763440 );
insert into mv_compression.compress_MATRIX values(187 ,
.0006684490 , .0013368980 , .0020053480 , .0026737970 ,
.0033422460 , .0040106950 , .0046791440 , .0053475940 );
insert into mv_compression.compress_MATRIX values(188 ,
.0006648940 , .0013297870 , .0019946810 , .0026595740 ,
.0033244680 , .0039893620 , .0046542550 , .0053191490 );
insert into mv_compression.compress_MATRIX values(189 ,
.0006613760 , .0013227510 , .0019841270 , .0026455030 ,
.0033068780 , .0039682540 , .0046296300 , .0052910050 );
insert into mv_compression.compress_MATRIX values(19 ,
.0065789470 , .0131578950 , .0197368420 , .0263157890 ,
.0328947370 , .0394736840 , .0460526320 , .0526315790 );
insert into mv_compression.compress_MATRIX values(190 ,
.0006578950 , .0013157890 , .0019736840 , .0026315790 ,
.0032894740 , .0039473680 , .0046052630 , .0052631580 );
insert into mv_compression.compress_MATRIX values(191 ,
.0006544500 , .0013089010 , .0019633510 , .0026178010 ,
.0032722510 , .0039267020 , .0045811520 , .0052356020 );
insert into mv_compression.compress_MATRIX values(192 ,
.0006510420 , .0013020830 , .0019531250 , .0026041670 ,
.0032552080 , .0039062500 , .0045572920 , .0052083330 );
insert into mv_compression.compress_MATRIX values(193 ,
.0006476680 , .0012953370 , .0019430050 , .0025906740 ,
.0032383420 , .0038860100 , .0045336790 , .0051813470 );
insert into mv_compression.compress_MATRIX values(194 ,
.0006443300 , .0012886600 , .0019329900 , .0025773200 ,
.0032216490 , .0038659790 , .0045103090 , .0051546390 );
insert into mv_compression.compress_MATRIX values(195 ,
.0006410260 , .0012820510 , .0019230770 , .0025641030 ,
.0032051280 , .0038461540 , .0044871790 , .0051282050 );
insert into mv_compression.compress_MATRIX values(196 ,
.0006377550 , .0012755100 , .0019132650 , .0025510200 ,
.0031887760 , .0038265310 , .0044642860 , .0051020410 );
insert into mv_compression.compress_MATRIX values(197 ,
.0006345180 , .0012690360 , .0019035530 , .0025380710 ,
.0031725890 , .0038071070 , .0044416240 , .0050761420 );
insert into mv_compression.compress_MATRIX values(198 ,
.0006313130 , .0012626260 , .0018939390 , .0025252530 ,
.0031565660 , .0037878790 , .0044191920 , .0050505050 );
insert into mv_compression.compress_MATRIX values(199 ,
.0006281410 , .0012562810 , .0018844220 , .0025125630 ,
.0031407040 , .0037688440 , .0043969850 , .0050251260 );
insert into mv_compression.compress_MATRIX values(2 , .0625000000
, .1250000000 , .1875000000 , .2500000000 ,
.3125000000 , .3750000000 , .4375000000 , .5000000000 );
insert into mv_compression.compress_MATRIX values(20 ,
.0062500000 , .0125000000 , .0187500000 , .0250000000 ,
.0312500000 , .0375000000 , .0437500000 , .0500000000 );
insert into mv_compression.compress_MATRIX values(200 ,
.0006250000 , .0012500000 , .0018750000 , .0025000000 ,
.0031250000 , .0037500000 , .0043750000 , .0050000000 );
insert into mv_compression.compress_MATRIX values(201 ,
.0006218910 , .0012437810 , .0018656720 , .0024875620 ,
.0031094530 , .0037313430 , .0043532340 , .0049751240 );
insert into mv_compression.compress_MATRIX values(202 ,
.0006188120 , .0012376240 , .0018564360 , .0024752480 ,
.0030940590 , .0037128710 , .0043316830 , .0049504950 );
insert into mv_compression.compress_MATRIX values(203 ,
.0006157640 , .0012315270 , .0018472910 , .0024630540 ,
.0030788180 , .0036945810 , .0043103450 , .0049261080 );
insert into mv_compression.compress_MATRIX values(204 ,
.0006127450 , .0012254900 , .0018382350 , .0024509800 ,
.0030637250 , .0036764710 , .0042892160 , .0049019610 );
insert into mv_compression.compress_MATRIX values(205 ,
.0006097560 , .0012195120 , .0018292680 , .0024390240 ,
.0030487800 , .0036585370 , .0042682930 , .0048780490 );
insert into mv_compression.compress_MATRIX values(206 ,
.0006067960 , .0012135920 , .0018203880 , .0024271840 ,
.0030339810 , .0036407770 , .0042475730 , .0048543690 );
insert into mv_compression.compress_MATRIX values(207 ,
.0006038650 , .0012077290 , .0018115940 , .0024154590 ,
.0030193240 , .0036231880 , .0042270530 , .0048309180 );
insert into mv_compression.compress_MATRIX values(208 ,
.0006009620 , .0012019230 , .0018028850 , .0024038460 ,
.0030048080 , .0036057690 , .0042067310 , .0048076920 );
insert into mv_compression.compress_MATRIX values(209 ,
.0005980860 , .0011961720 , .0017942580 , .0023923440 ,
.0029904310 , .0035885170 , .0041866030 , .0047846890 );
insert into mv_compression.compress_MATRIX values(21 ,
.0059523810 , .0119047620 , .0178571430 , .0238095240 ,
.0297619050 , .0357142860 , .0416666670 , .0476190480 );
insert into mv_compression.compress_MATRIX values(210 ,
.0005952380 , .0011904760 , .0017857140 , .0023809520 ,
.0029761900 , .0035714290 , .0041666670 , .0047619050 );
insert into mv_compression.compress_MATRIX values(211 ,
.0005924170 , .0011848340 , .0017772510 , .0023696680 ,
.0029620850 , .0035545020 , .0041469190 , .0047393360 );
insert into mv_compression.compress_MATRIX values(212 ,
.0005896230 , .0011792450 , .0017688680 , .0023584910 ,
.0029481130 , .0035377360 , .0041273580 , .0047169810 );
insert into mv_compression.compress_MATRIX values(213 ,
.0005868540 , .0011737090 , .0017605630 , .0023474180 ,
.0029342720 , .0035211270 , .0041079810 , .0046948360 );
insert into mv_compression.compress_MATRIX values(214 ,
.0005841120 , .0011682240 , .0017523360 , .0023364490 ,
.0029205610 , .0035046730 , .0040887850 , .0046728970 );
insert into mv_compression.compress_MATRIX values(215 ,
.0005813950 , .0011627910 , .0017441860 , .0023255810 ,
.0029069770 , .0034883720 , .0040697670 , .0046511630 );
insert into mv_compression.compress_MATRIX values(216 ,
.0005787040 , .0011574070 , .0017361110 , .0023148150 ,
.0028935190 , .0034722220 , .0040509260 , .0046296300 );
insert into mv_compression.compress_MATRIX values(217 ,
.0005760370 , .0011520740 , .0017281110 , .0023041470 ,
.0028801840 , .0034562210 , .0040322580 , .0046082950 );
insert into mv_compression.compress_MATRIX values(218 ,
.0005733940 , .0011467890 , .0017201830 , .0022935780 ,
.0028669720 , .0034403670 , .0040137610 , .0045871560 );
insert into mv_compression.compress_MATRIX values(219 ,
.0005707760 , .0011415530 , .0017123290 , .0022831050 ,
.0028538810 , .0034246580 , .0039954340 , .0045662100 );
insert into mv_compression.compress_MATRIX values(22 ,
.0056818180 , .0113636360 , .0170454550 , .0227272730 ,
.0284090910 , .0340909090 , .0397727270 , .0454545450 );
insert into mv_compression.compress_MATRIX values(220 ,
.0005681820 , .0011363640 , .0017045450 , .0022727270 ,
.0028409090 , .0034090910 , .0039772730 , .0045454550 );
insert into mv_compression.compress_MATRIX values(221 ,
.0005656110 , .0011312220 , .0016968330 , .0022624430 ,
.0028280540 , .0033936650 , .0039592760 , .0045248870 );
insert into mv_compression.compress_MATRIX values(222 ,
.0005630630 , .0011261260 , .0016891890 , .0022522520 ,
.0028153150 , .0033783780 , .0039414410 , .0045045050 );
insert into mv_compression.compress_MATRIX values(223 ,
.0005605380 , .0011210760 , .0016816140 , .0022421520 ,
.0028026910 , .0033632290 , .0039237670 , .0044843050 );
insert into mv_compression.compress_MATRIX values(224 ,
.0005580360 , .0011160710 , .0016741070 , .0022321430 ,
.0027901790 , .0033482140 , .0039062500 , .0044642860 );
insert into mv_compression.compress_MATRIX values(225 ,
.0005555560 , .0011111110 , .0016666670 , .0022222220 ,
.0027777780 , .0033333330 , .0038888890 , .0044444440 );
insert into mv_compression.compress_MATRIX values(226 ,
.0005530970 , .0011061950 , .0016592920 , .0022123890 ,
.0027654870 , .0033185840 , .0038716810 , .0044247790 );
insert into mv_compression.compress_MATRIX values(227 ,
.0005506610 , .0011013220 , .0016519820 , .0022026430 ,
.0027533040 , .0033039650 , .0038546260 , .0044052860 );
insert into mv_compression.compress_MATRIX values(228 ,
.0005482460 , .0010964910 , .0016447370 , .0021929820 ,
.0027412280 , .0032894740 , .0038377190 , .0043859650 );
insert into mv_compression.compress_MATRIX values(229 ,
.0005458520 , .0010917030 , .0016375550 , .0021834060 ,
.0027292580 , .0032751090 , .0038209610 , .0043668120 );
insert into mv_compression.compress_MATRIX values(23 ,
.0054347830 , .0108695650 , .0163043480 , .0217391300 ,
.0271739130 , .0326086960 , .0380434780 , .0434782610 );
insert into mv_compression.compress_MATRIX values(230 ,
.0005434780 , .0010869570 , .0016304350 , .0021739130 ,
.0027173910 , .0032608700 , .0038043480 , .0043478260 );
insert into mv_compression.compress_MATRIX values(231 ,
.0005411260 , .0010822510 , .0016233770 , .0021645020 ,
.0027056280 , .0032467530 , .0037878790 , .0043290040 );
insert into mv_compression.compress_MATRIX values(232 ,
.0005387930 , .0010775860 , .0016163790 , .0021551720 ,
.0026939660 , .0032327590 , .0037715520 , .0043103450 );
insert into mv_compression.compress_MATRIX values(233 ,
.0005364810 , .0010729610 , .0016094420 , .0021459230 ,
.0026824030 , .0032188840 , .0037553650 , .0042918450 );
insert into mv_compression.compress_MATRIX values(234 ,
.0005341880 , .0010683760 , .0016025640 , .0021367520 ,
.0026709400 , .0032051280 , .0037393160 , .0042735040 );
insert into mv_compression.compress_MATRIX values(235 ,
.0005319150 , .0010638300 , .0015957450 , .0021276600 ,
.0026595740 , .0031914890 , .0037234040 , .0042553190 );
insert into mv_compression.compress_MATRIX values(236 ,
.0005296610 , .0010593220 , .0015889830 , .0021186440 ,
.0026483050 , .0031779660 , .0037076270 , .0042372880 );
insert into mv_compression.compress_MATRIX values(237 ,
.0005274260 , .0010548520 , .0015822780 , .0021097050 ,
.0026371310 , .0031645570 , .0036919830 , .0042194090 );
insert into mv_compression.compress_MATRIX values(238 ,
.0005252100 , .0010504200 , .0015756300 , .0021008400 ,
.0026260500 , .0031512610 , .0036764710 , .0042016810 );
insert into mv_compression.compress_MATRIX values(239 ,
.0005230130 , .0010460250 , .0015690380 , .0020920500 ,
.0026150630 , .0031380750 , .0036610880 , .0041841000 );
insert into mv_compression.compress_MATRIX values(24 ,
.0052083330 , .0104166670 , .0156250000 , .0208333330 ,
.0260416670 , .0312500000 , .0364583330 , .0416666670 );
insert into mv_compression.compress_MATRIX values(240 ,
.0005208330 , .0010416670 , .0015625000 , .0020833330 ,
.0026041670 , .0031250000 , .0036458330 , .0041666670 );
insert into mv_compression.compress_MATRIX values(241 ,
.0005186720 , .0010373440 , .0015560170 , .0020746890 ,
.0025933610 , .0031120330 , .0036307050 , .0041493780 );
insert into mv_compression.compress_MATRIX values(242 ,
.0005165290 , .0010330580 , .0015495870 , .0020661160 ,
.0025826450 , .0030991740 , .0036157020 , .0041322310 );
insert into mv_compression.compress_MATRIX values(243 ,
.0005144030 , .0010288070 , .0015432100 , .0020576130 ,
.0025720160 , .0030864200 , .0036008230 , .0041152260 );
insert into mv_compression.compress_MATRIX values(244 ,
.0005122950 , .0010245900 , .0015368850 , .0020491800 ,
.0025614750 , .0030737700 , .0035860660 , .0040983610 );
insert into mv_compression.compress_MATRIX values(245 ,
.0005102040 , .0010204080 , .0015306120 , .0020408160 ,
.0025510200 , .0030612240 , .0035714290 , .0040816330 );
insert into mv_compression.compress_MATRIX values(246 ,
.0005081300 , .0010162600 , .0015243900 , .0020325200 ,
.0025406500 , .0030487800 , .0035569110 , .0040650410 );
insert into mv_compression.compress_MATRIX values(247 ,
.0005060730 , .0010121460 , .0015182190 , .0020242910 ,
.0025303640 , .0030364370 , .0035425100 , .0040485830 );
insert into mv_compression.compress_MATRIX values(248 ,
.0005040320 , .0010080650 , .0015120970 , .0020161290 ,
.0025201610 , .0030241940 , .0035282260 , .0040322580 );
insert into mv_compression.compress_MATRIX values(249 ,
.0005020080 , .0010040160 , .0015060240 , .0020080320 ,
.0025100400 , .0030120480 , .0035140560 , .0040160640 );
insert into mv_compression.compress_MATRIX values(25 ,
.0050000000 , .0100000000 , .0150000000 , .0200000000 ,
.0250000000 , .0300000000 , .0350000000 , .0400000000 );
insert into mv_compression.compress_MATRIX values(250 ,
.0005000000 , .0010000000 , .0015000000 , .0020000000 ,
.0025000000 , .0030000000 , .0035000000 , .0040000000 );
insert into mv_compression.compress_MATRIX values(251 ,
.0004980080 , .0009960160 , .0014940240 , .0019920320 ,
.0024900400 , .0029880480 , .0034860560 , .0039840640 );
insert into mv_compression.compress_MATRIX values(252 ,
.0004960320 , .0009920630 , .0014880950 , .0019841270 ,
.0024801590 , .0029761900 , .0034722220 , .0039682540 );
insert into mv_compression.compress_MATRIX values(253 ,
.0004940710 , .0009881420 , .0014822130 , .0019762850 ,
.0024703560 , .0029644270 , .0034584980 , .0039525690 );
insert into mv_compression.compress_MATRIX values(254 ,
.0004921260 , .0009842520 , .0014763780 , .0019685040 ,
.0024606300 , .0029527560 , .0034448820 , .0039370080 );
insert into mv_compression.compress_MATRIX values(255 ,
.0004901960 , .0009803920 , .0014705880 , .0019607840 ,
.0024509800 , .0029411760 , .0034313730 , .0039215690 );
insert into mv_compression.compress_MATRIX values(26 ,
.0048076920 , .0096153850 , .0144230770 , .0192307690 ,
.0240384620 , .0288461540 , .0336538460 , .0384615380 );
insert into mv_compression.compress_MATRIX values(27 ,
.0046296300 , .0092592590 , .0138888890 , .0185185190 ,
.0231481480 , .0277777780 , .0324074070 , .0370370370 );
insert into mv_compression.compress_MATRIX values(28 ,
.0044642860 , .0089285710 , .0133928570 , .0178571430 ,
.0223214290 , .0267857140 , .0312500000 , .0357142860 );
insert into mv_compression.compress_MATRIX values(29 ,
.0043103450 , .0086206900 , .0129310340 , .0172413790 ,
.0215517240 , .0258620690 , .0301724140 , .0344827590 );
insert into mv_compression.compress_MATRIX values(3 , .0416666670
, .0833333330 , .1250000000 , .1666666670 ,
.2083333330 , .2500000000 , .2916666670 , .3333333330 );
insert into mv_compression.compress_MATRIX values(30 ,
.0041666670 , .0083333330 , .0125000000 , .0166666670 ,
.0208333330 , .0250000000 , .0291666670 , .0333333330 );
insert into mv_compression.compress_MATRIX values(31 ,
.0040322580 , .0080645160 , .0120967740 , .0161290320 ,
.0201612900 , .0241935480 , .0282258060 , .0322580650 );
insert into mv_compression.compress_MATRIX values(32 ,
.0039062500 , .0078125000 , .0117187500 , .0156250000 ,
.0195312500 , .0234375000 , .0273437500 , .0312500000 );
insert into mv_compression.compress_MATRIX values(33 ,
.0037878790 , .0075757580 , .0113636360 , .0151515150 ,
.0189393940 , .0227272730 , .0265151520 , .0303030300 );
insert into mv_compression.compress_MATRIX values(34 ,
.0036764710 , .0073529410 , .0110294120 , .0147058820 ,
.0183823530 , .0220588240 , .0257352940 , .0294117650 );
insert into mv_compression.compress_MATRIX values(35 ,
.0035714290 , .0071428570 , .0107142860 , .0142857140 ,
.0178571430 , .0214285710 , .0250000000 , .0285714290 );
insert into mv_compression.compress_MATRIX values(36 ,
.0034722220 , .0069444440 , .0104166670 , .0138888890 ,
.0173611110 , .0208333330 , .0243055560 , .0277777780 );
insert into mv_compression.compress_MATRIX values(37 ,
.0033783780 , .0067567570 , .0101351350 , .0135135140 ,
.0168918920 , .0202702700 , .0236486490 , .0270270270 );
insert into mv_compression.compress_MATRIX values(38 ,
.0032894740 , .0065789470 , .0098684210 , .0131578950 ,
.0164473680 , .0197368420 , .0230263160 , .0263157890 );
insert into mv_compression.compress_MATRIX values(39 ,
.0032051280 , .0064102560 , .0096153850 , .0128205130 ,
.0160256410 , .0192307690 , .0224358970 , .0256410260 );
insert into mv_compression.compress_MATRIX values(4 , .0312500000
, .0625000000 , .0937500000 , .1250000000 ,
.1562500000 , .1875000000 , .2187500000 , .2500000000 );
insert into mv_compression.compress_MATRIX values(40 ,
.0031250000 , .0062500000 , .0093750000 , .0125000000 ,
.0156250000 , .0187500000 , .0218750000 , .0250000000 );
insert into mv_compression.compress_MATRIX values(41 ,
.0030487800 , .0060975610 , .0091463410 , .0121951220 ,
.0152439020 , .0182926830 , .0213414630 , .0243902440 );
insert into mv_compression.compress_MATRIX values(42 ,
.0029761900 , .0059523810 , .0089285710 , .0119047620 ,
.0148809520 , .0178571430 , .0208333330 , .0238095240 );
insert into mv_compression.compress_MATRIX values(43 ,
.0029069770 , .0058139530 , .0087209300 , .0116279070 ,
.0145348840 , .0174418600 , .0203488370 , .0232558140 );
insert into mv_compression.compress_MATRIX values(44 ,
.0028409090 , .0056818180 , .0085227270 , .0113636360 ,
.0142045450 , .0170454550 , .0198863640 , .0227272730 );
insert into mv_compression.compress_MATRIX values(45 ,
.0027777780 , .0055555560 , .0083333330 , .0111111110 ,
.0138888890 , .0166666670 , .0194444440 , .0222222220 );
insert into mv_compression.compress_MATRIX values(46 ,
.0027173910 , .0054347830 , .0081521740 , .0108695650 ,
.0135869570 , .0163043480 , .0190217390 , .0217391300 );
insert into mv_compression.compress_MATRIX values(47 ,
.0026595740 , .0053191490 , .0079787230 , .0106382980 ,
.0132978720 , .0159574470 , .0186170210 , .0212765960 );
insert into mv_compression.compress_MATRIX values(48 ,
.0026041670 , .0052083330 , .0078125000 , .0104166670 ,
.0130208330 , .0156250000 , .0182291670 , .0208333330 );
insert into mv_compression.compress_MATRIX values(49 ,
.0025510200 , .0051020410 , .0076530610 , .0102040820 ,
.0127551020 , .0153061220 , .0178571430 , .0204081630 );
insert into mv_compression.compress_MATRIX values(5 , .0250000000
, .0500000000 , .0750000000 , .1000000000 ,
.1250000000 , .1500000000 , .1750000000 , .2000000000 );
insert into mv_compression.compress_MATRIX values(50 ,
.0025000000 , .0050000000 , .0075000000 , .0100000000 ,
.0125000000 , .0150000000 , .0175000000 , .0200000000 );
insert into mv_compression.compress_MATRIX values(51 ,
.0024509800 , .0049019610 , .0073529410 , .0098039220 ,
.0122549020 , .0147058820 , .0171568630 , .0196078430 );
insert into mv_compression.compress_MATRIX values(52 ,
.0024038460 , .0048076920 , .0072115380 , .0096153850 ,
.0120192310 , .0144230770 , .0168269230 , .0192307690 );
insert into mv_compression.compress_MATRIX values(53 ,
.0023584910 , .0047169810 , .0070754720 , .0094339620 ,
.0117924530 , .0141509430 , .0165094340 , .0188679250 );
insert into mv_compression.compress_MATRIX values(54 ,
.0023148150 , .0046296300 , .0069444440 , .0092592590 ,
.0115740740 , .0138888890 , .0162037040 , .0185185190 );
insert into mv_compression.compress_MATRIX values(55 ,
.0022727270 , .0045454550 , .0068181820 , .0090909090 ,
.0113636360 , .0136363640 , .0159090910 , .0181818180 );
insert into mv_compression.compress_MATRIX values(56 ,
.0022321430 , .0044642860 , .0066964290 , .0089285710 ,
.0111607140 , .0133928570 , .0156250000 , .0178571430 );
insert into mv_compression.compress_MATRIX values(57 ,
.0021929820 , .0043859650 , .0065789470 , .0087719300 ,
.0109649120 , .0131578950 , .0153508770 , .0175438600 );
insert into mv_compression.compress_MATRIX values(58 ,
.0021551720 , .0043103450 , .0064655170 , .0086206900 ,
.0107758620 , .0129310340 , .0150862070 , .0172413790 );
insert into mv_compression.compress_MATRIX values(59 ,
.0021186440 , .0042372880 , .0063559320 , .0084745760 ,
.0105932200 , .0127118640 , .0148305080 , .0169491530 );
insert into mv_compression.compress_MATRIX values(6 , .0208333330
, .0416666670 , .0625000000 , .0833333330 ,
.1041666670 , .1250000000 , .1458333330 , .1666666670 );
insert into mv_compression.compress_MATRIX values(60 ,
.0020833330 , .0041666670 , .0062500000 , .0083333330 ,
.0104166670 , .0125000000 , .0145833330 , .0166666670 );
insert into mv_compression.compress_MATRIX values(61 ,
.0020491800 , .0040983610 , .0061475410 , .0081967210 ,
.0102459020 , .0122950820 , .0143442620 , .0163934430 );
insert into mv_compression.compress_MATRIX values(62 ,
.0020161290 , .0040322580 , .0060483870 , .0080645160 ,
.0100806450 , .0120967740 , .0141129030 , .0161290320 );
insert into mv_compression.compress_MATRIX values(63 ,
.0019841270 , .0039682540 , .0059523810 , .0079365080 ,
.0099206350 , .0119047620 , .0138888890 , .0158730160 );
insert into mv_compression.compress_MATRIX values(64 ,
.0019531250 , .0039062500 , .0058593750 , .0078125000 ,
.0097656250 , .0117187500 , .0136718750 , .0156250000 );
insert into mv_compression.compress_MATRIX values(65 ,
.0019230770 , .0038461540 , .0057692310 , .0076923080 ,
.0096153850 , .0115384620 , .0134615380 , .0153846150 );
insert into mv_compression.compress_MATRIX values(66 ,
.0018939390 , .0037878790 , .0056818180 , .0075757580 ,
.0094696970 , .0113636360 , .0132575760 , .0151515150 );
insert into mv_compression.compress_MATRIX values(67 ,
.0018656720 , .0037313430 , .0055970150 , .0074626870 ,
.0093283580 , .0111940300 , .0130597010 , .0149253730 );
insert into mv_compression.compress_MATRIX values(68 ,
.0018382350 , .0036764710 , .0055147060 , .0073529410 ,
.0091911760 , .0110294120 , .0128676470 , .0147058820 );
insert into mv_compression.compress_MATRIX values(69 ,
.0018115940 , .0036231880 , .0054347830 , .0072463770 ,
.0090579710 , .0108695650 , .0126811590 , .0144927540 );
insert into mv_compression.compress_MATRIX values(7 , .0178571430
, .0357142860 , .0535714290 , .0714285710 ,
.0892857140 , .1071428570 , .1250000000 , .1428571430 );
insert into mv_compression.compress_MATRIX values(70 ,
.0017857140 , .0035714290 , .0053571430 , .0071428570 ,
.0089285710 , .0107142860 , .0125000000 , .0142857140 );
insert into mv_compression.compress_MATRIX values(71 ,
.0017605630 , .0035211270 , .0052816900 , .0070422540 ,
.0088028170 , .0105633800 , .0123239440 , .0140845070 );
insert into mv_compression.compress_MATRIX values(72 ,
.0017361110 , .0034722220 , .0052083330 , .0069444440 ,
.0086805560 , .0104166670 , .0121527780 , .0138888890 );
insert into mv_compression.compress_MATRIX values(73 ,
.0017123290 , .0034246580 , .0051369860 , .0068493150 ,
.0085616440 , .0102739730 , .0119863010 , .0136986300 );
insert into mv_compression.compress_MATRIX values(74 ,
.0016891890 , .0033783780 , .0050675680 , .0067567570 ,
.0084459460 , .0101351350 , .0118243240 , .0135135140 );
insert into mv_compression.compress_MATRIX values(75 ,
.0016666670 , .0033333330 , .0050000000 , .0066666670 ,
.0083333330 , .0100000000 , .0116666670 , .0133333330 );
insert into mv_compression.compress_MATRIX values(76 ,
.0016447370 , .0032894740 , .0049342110 , .0065789470 ,
.0082236840 , .0098684210 , .0115131580 , .0131578950 );
insert into mv_compression.compress_MATRIX values(77 ,
.0016233770 , .0032467530 , .0048701300 , .0064935060 ,
.0081168830 , .0097402600 , .0113636360 , .0129870130 );
insert into mv_compression.compress_MATRIX values(78 ,
.0016025640 , .0032051280 , .0048076920 , .0064102560 ,
.0080128210 , .0096153850 , .0112179490 , .0128205130 );
insert into mv_compression.compress_MATRIX values(79 ,
.0015822780 , .0031645570 , .0047468350 , .0063291140 ,
.0079113920 , .0094936710 , .0110759490 , .0126582280 );
insert into mv_compression.compress_MATRIX values(8 , .0156250000
, .0312500000 , .0468750000 , .0625000000 ,
.0781250000 , .0937500000 , .1093750000 , .1250000000 );
insert into mv_compression.compress_MATRIX values(80 ,
.0015625000 , .0031250000 , .0046875000 , .0062500000 ,
.0078125000 , .0093750000 , .0109375000 , .0125000000 );
insert into mv_compression.compress_MATRIX values(81 ,
.0015432100 , .0030864200 , .0046296300 , .0061728400 ,
.0077160490 , .0092592590 , .0108024690 , .0123456790 );
insert into mv_compression.compress_MATRIX values(82 ,
.0015243900 , .0030487800 , .0045731710 , .0060975610 ,
.0076219510 , .0091463410 , .0106707320 , .0121951220 );
insert into mv_compression.compress_MATRIX values(83 ,
.0015060240 , .0030120480 , .0045180720 , .0060240960 ,
.0075301200 , .0090361450 , .0105421690 , .0120481930 );
insert into mv_compression.compress_MATRIX values(84 ,
.0014880950 , .0029761900 , .0044642860 , .0059523810 ,
.0074404760 , .0089285710 , .0104166670 , .0119047620 );
insert into mv_compression.compress_MATRIX values(85 ,
.0014705880 , .0029411760 , .0044117650 , .0058823530 ,
.0073529410 , .0088235290 , .0102941180 , .0117647060 );
insert into mv_compression.compress_MATRIX values(86 ,
.0014534880 , .0029069770 , .0043604650 , .0058139530 ,
.0072674420 , .0087209300 , .0101744190 , .0116279070 );
insert into mv_compression.compress_MATRIX values(87 ,
.0014367820 , .0028735630 , .0043103450 , .0057471260 ,
.0071839080 , .0086206900 , .0100574710 , .0114942530 );
insert into mv_compression.compress_MATRIX values(88 ,
.0014204550 , .0028409090 , .0042613640 , .0056818180 ,
.0071022730 , .0085227270 , .0099431820 , .0113636360 );
insert into mv_compression.compress_MATRIX values(89 ,
.0014044940 , .0028089890 , .0042134830 , .0056179780 ,
.0070224720 , .0084269660 , .0098314610 , .0112359550 );
insert into mv_compression.compress_MATRIX values(9 , .0138888890
, .0277777780 , .0416666670 , .0555555560 ,
.0694444440 , .0833333330 , .0972222220 , .1111111110 );
insert into mv_compression.compress_MATRIX values(90 ,
.0013888890 , .0027777780 , .0041666670 , .0055555560 ,
.0069444440 , .0083333330 , .0097222220 , .0111111110 );
insert into mv_compression.compress_MATRIX values(91 ,
.0013736260 , .0027472530 , .0041208790 , .0054945050 ,
.0068681320 , .0082417580 , .0096153850 , .0109890110 );
insert into mv_compression.compress_MATRIX values(92 ,
.0013586960 , .0027173910 , .0040760870 , .0054347830 ,
.0067934780 , .0081521740 , .0095108700 , .0108695650 );
insert into mv_compression.compress_MATRIX values(93 ,
.0013440860 , .0026881720 , .0040322580 , .0053763440 ,
.0067204300 , .0080645160 , .0094086020 , .0107526880 );
insert into mv_compression.compress_MATRIX values(94 ,
.0013297870 , .0026595740 , .0039893620 , .0053191490 ,
.0066489360 , .0079787230 , .0093085110 , .0106382980 );
insert into mv_compression.compress_MATRIX values(95 ,
.0013157890 , .0026315790 , .0039473680 , .0052631580 ,
.0065789470 , .0078947370 , .0092105260 , .0105263160 );
insert into mv_compression.compress_MATRIX values(96 ,
.0013020830 , .0026041670 , .0039062500 , .0052083330 ,
.0065104170 , .0078125000 , .0091145830 , .0104166670 );
insert into mv_compression.compress_MATRIX values(97 ,
.0012886600 , .0025773200 , .0038659790 , .0051546390 ,
.0064432990 , .0077319590 , .0090206190 , .0103092780 );
insert into mv_compression.compress_MATRIX values(98 ,
.0012755100 , .0025510200 , .0038265310 , .0051020410 ,
.0063775510 , .0076530610 , .0089285710 , .0102040820 );
insert into mv_compression.compress_MATRIX values(99 ,
.0012626260 , .0025252530 , .0037878790 , .0050505050 ,
.0063131310 , .0075757580 , .0088383840 , .0101010100 );
collect statistics on mv_compression.compress_MATRIX index
UPI_COMPRESS_MATRIX;
| ||||||||||||||||||||||||||||||||||||||||||||||
| | ||||||||||||||||||||||||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||||||||||||||||||||||
| Copyright 2016 - All Rights Reserved | ||||||||||||||||||||||||||||||||||||||||||||||||
| Last Modified: 15 Jun 2023 | ||||||||||||||||||||||||||||||||||||||||||||||||
