Partition_tools package
Package was run against 10 and 11 g database but I assume it could run against any db version. This package has in fact two main functionality:- Count number of records in partition table on several ways
- Function which will help me generating equal number of buckets for some data set
CREATE OR REPLACE PACKAGE partition_tools
/* $Header: partition_tools 1.00 09/23/2013 13:13 damirv $ */
/*--------------------------------------------------------------------------------------------------------------------
NAME : partition_tools
PURPOSE : procedure that are used with partitions ... tuning and analyzing
Date : 23.09.2013.
Author : Damir Vadas, damir.vadas@gmail.com
Remarks : Package was run against 10 and 11 g database but I assume it could run against any db version.
Changes (DD.MM.YYYY, Name, CR/TR#):
-------------------------------------------------------------------------------------------------------------------- */
AUTHID CURRENT_USER
IS
PROCEDURE recs_in_partition (p_partitions VARCHAR2,
p_part_table_owner VARCHAR2,
p_part_table_name VARCHAR2,
p_from_statistic VARCHAR2 DEFAULT 'N' -- Y -> read num_rows from statistic (all_tab_partitions) QUICKER!
-- N -> dinamically execute sql and get real number of rows
);
FUNCTION recs_in_partition (p_partitions VARCHAR2,
p_part_table_owner VARCHAR2,
p_part_table_name VARCHAR2,
p_from_statistic VARCHAR2 DEFAULT 'N'
) RETURN VARCHAR2;
FUNCTION running_sum_with_reset(
p_rownum NUMBER,
p_value NUMBER,
p_break_limit NUMBER,
p_reset_value NUMBER DEFAULT 0
) RETURN NUMBER;
FUNCTION running_sum_with_reset (
p_rownum NUMBER,
p_value NUMBER, -- current value that is added to sum
p_break_limit NUMBER, -- initial partition width (bucket)
p_reset_value NUMBER, -- when break come what value should running sum get
p_max_percentage NUMBER -- percentage in which bucket values may fall upper bound
) RETURN NUMBER;
END partition_tools;
/
CREATE OR REPLACE PACKAGE BODY partition_tools
IS
g_sum NUMBER;
g_max_treshold NUMBER;
--
CURSOR c1 (cp_part_table_owner IN VARCHAR2, cp_part_table_name IN VARCHAR2)
IS
SELECT table_name, partition_name
FROM all_tab_partitions
WHERE TABLE_OWNER = cp_part_table_owner AND table_name = cp_part_table_name
ORDER BY partition_position
;
--
CURSOR c2 (cp_part_table_owner IN VARCHAR2, cp_part_table_name IN VARCHAR2, cp_start IN PLS_INTEGER, cp_end IN PLS_INTEGER)
IS
SELECT rownum rn, table_name, partition_name
FROM all_tab_partitions
WHERE TABLE_OWNER = cp_part_table_owner AND TABLE_NAME = cp_part_table_name and PARTITION_POSITION BETWEEN cp_start and cp_end
ORDER BY PARTITION_POSITION
;
l_partitions1 NUMBER;
l_partitions2 NUMBER;
--
CURSOR cs1 (cp_part_table_owner IN VARCHAR2, cp_part_table_name IN VARCHAR2)
IS
SELECT partition_name, num_rows
FROM all_tab_partitions
WHERE TABLE_OWNER = cp_part_table_owner AND table_name = cp_part_table_name
ORDER BY partition_position
;
--
CURSOR cs2 (cp_part_table_owner IN VARCHAR2, cp_part_table_name IN VARCHAR2, cp_start IN PLS_INTEGER, cp_end IN PLS_INTEGER)
IS
SELECT partition_name, num_rows
FROM all_tab_partitions
WHERE TABLE_OWNER = cp_part_table_owner AND table_name = cp_part_table_name and PARTITION_POSITION BETWEEN cp_start and cp_end
ORDER BY PARTITION_POSITION
;
--
CURSOR cs3 (cp_part_table_owner IN VARCHAR2, cp_part_table_name IN VARCHAR2, cp_partition_name IN VARCHAR2 )
IS
SELECT partition_name, num_rows
FROM all_tab_partitions
WHERE TABLE_OWNER = cp_part_table_owner AND table_name = cp_part_table_name AND partition_name = cp_partition_name
;
--
FUNCTION is_number (
char_in VARCHAR2
) RETURN BOOLEAN
IS
n NUMBER;
BEGIN
n := TO_NUMBER(nvl(char_in,'a'));
RETURN TRUE;
EXCEPTION
WHEN OTHERS THEN
RETURN FALSE;
END is_number;
--
PROCEDURE recs_in_partition (
p_partitions VARCHAR2,
p_part_table_owner VARCHAR2,
p_part_table_name VARCHAR2,
p_from_statistic VARCHAR2 DEFAULT 'N'
)
IS
l_chartab sys.DBMS_DEBUG_VC2COLL := sys.DBMS_DEBUG_VC2COLL();
l_temp_var NUMBER := 0;
l_partition_counter NUMBER DEFAULT 0;
--
BEGIN
BEGIN
SELECT column_value
BULK COLLECT
INTO l_chartab
FROM TABLE(tools.list2table(p_partitions));
CASE l_chartab.COUNT
WHEN 2 THEN -- maybe a number range is a parameter (it may be two partitions!!)
CASE
WHEN is_number(l_chartab(1)) AND is_number(l_chartab(2)) THEN -- not a prtition name because it cannot be a nnumber!
l_partitions1 := l_chartab(1);
l_partitions2 := l_chartab(2);
ELSE
l_partitions1 := -1;
l_partitions1 := -2;
END CASE;
ELSE
l_partitions1 := -1;
l_partitions1 := -2;
END CASE;
EXCEPTION
WHEN OTHERS THEN
l_partitions1 := -1;
l_partitions2 := -2;
END;
--
CASE
WHEN p_partitions = 'ALL' THEN
CASE p_from_statistic
WHEN 'Y' THEN
FOR rec IN cs1 (p_part_table_owner,p_part_table_name) LOOP
DBMS_OUTPUT.put_line (rec.partition_name || '=' || LPAD (rec.num_rows, 12, ' ') || ' rows');
END LOOP;
ELSE
FOR rec IN c1 (p_part_table_owner,p_part_table_name) LOOP
EXECUTE IMMEDIATE 'select count(*) from ' ||p_part_table_owner||'.' || rec.table_name || ' partition(' || rec.partition_name || ')' INTO l_temp_var;
DBMS_OUTPUT.put_line (rec.partition_name || '=' || LPAD (l_temp_var, 12, ' ') || ' rows');
END LOOP;
END CASE;
WHEN l_partitions1 > 0 THEN
CASE p_from_statistic
WHEN 'Y' THEN
FOR rec IN cs2 (p_part_table_owner,p_part_table_name, l_partitions1, (l_partitions1+l_partitions2) ) LOOP
CASE
WHEN l_partitions2 > l_partition_counter THEN
DBMS_OUTPUT.put_line (rec.partition_name || '=' || LPAD (rec.num_rows, 12, ' ') || ' rows');
l_partition_counter := l_partition_counter+1;
ELSE
EXIT;
END CASE;
END LOOP;
ELSE
FOR rec IN c2 (p_part_table_owner,p_part_table_name, l_partitions1, (l_partitions1+l_partitions2) ) LOOP
CASE
WHEN l_partitions2 > l_partition_counter THEN
EXECUTE IMMEDIATE 'select count(*) from ' ||p_part_table_owner||'.' || rec.table_name || ' partition(' || rec.partition_name || ')' INTO l_temp_var;
DBMS_OUTPUT.put_line (rec.partition_name || '=' || LPAD (l_temp_var, 12, ' ') || ' rows');
l_partition_counter := l_partition_counter+1;
ELSE
EXIT;
END CASE;
END LOOP;
END CASE;
ELSE -- list of partitions delimited with ","
SELECT column_value
BULK COLLECT
INTO l_chartab
FROM TABLE(tools.list2table(p_partitions));
CASE p_from_statistic
WHEN 'Y' THEN
FOR i IN 1 .. l_chartab.COUNT LOOP
FOR rec IN cs3 (p_part_table_owner,p_part_table_name,l_chartab(i)) LOOP
DBMS_OUTPUT.put_line (l_chartab(i)|| '=' || LPAD (rec.num_rows, 12, ' ') || ' rows');
END LOOP;
END LOOP;
ELSE
FOR i IN 1 .. l_chartab.COUNT LOOP
EXECUTE IMMEDIATE 'select count(*) from ' ||p_part_table_owner||'.' || p_part_table_name || ' partition(' || l_chartab(i) || ') ' INTO l_temp_var;
DBMS_OUTPUT.put_line (l_chartab(i) || '=' || LPAD (l_temp_var, 12, ' ') || ' rows');
END LOOP;
END CASE;
END CASE;
DBMS_SESSION.FREE_UNUSED_USER_MEMORY;
END;
--
FUNCTION recs_in_partition (
p_partitions VARCHAR2,
p_part_table_owner VARCHAR2,
p_part_table_name VARCHAR2,
p_from_statistic VARCHAR2 DEFAULT 'N'
) RETURN VARCHAR2
IS
l_retval VARCHAR2 (32000);
l_chartab sys.DBMS_DEBUG_VC2COLL := sys.DBMS_DEBUG_VC2COLL();
l_temp_var NUMBER := 0;
l_partition_counter NUMBER DEFAULT 0;
--
BEGIN
l_retVal := '';
BEGIN
SELECT column_value
BULK COLLECT
INTO l_chartab
FROM TABLE(tools.list2table(p_partitions));
CASE l_chartab.COUNT
WHEN 2 THEN -- maybe a number range is a parameter (it may be two partitions!!)
CASE
WHEN is_number(l_chartab(1)) AND is_number(l_chartab(2)) THEN -- not a prtition name because it cannot be a nnumber!
l_partitions1 := l_chartab(1);
l_partitions2 := l_chartab(2);
ELSE
l_partitions1 := -1;
l_partitions1 := -2;
END CASE;
ELSE
l_partitions1 := -1;
l_partitions1 := -2;
END CASE;
EXCEPTION
WHEN OTHERS THEN
l_partitions1 := -1;
l_partitions2 := -2;
END;
--
CASE
WHEN p_partitions = 'ALL' THEN
CASE p_from_statistic
WHEN 'Y' THEN
FOR rec IN cs1 (p_part_table_owner,p_part_table_name) LOOP
l_retVal := l_retVal || rec.num_rows || ',';
END LOOP;
ELSE
FOR rec IN c1 (p_part_table_owner,p_part_table_name) LOOP
EXECUTE IMMEDIATE 'select count(*) from ' ||p_part_table_owner||'.' || rec.table_name || ' partition(' || rec.partition_name || ')' INTO l_temp_var;
l_retVal := l_retVal || l_temp_var || ',';
END LOOP;
END CASE;
WHEN l_partitions1 > 0 THEN
CASE p_from_statistic
WHEN 'Y' THEN
FOR rec IN cs2 (p_part_table_owner,p_part_table_name, l_partitions1, (l_partitions1+l_partitions2) ) LOOP
CASE
WHEN l_partitions2 > l_partition_counter THEN
l_retVal := l_retVal || rec.num_rows || ',';
l_partition_counter := l_partition_counter+1;
ELSE
EXIT;
END CASE;
END LOOP;
ELSE
FOR rec IN c2 (p_part_table_owner,p_part_table_name, l_partitions1, (l_partitions1+l_partitions2) ) LOOP
CASE
WHEN l_partitions2 > l_partition_counter THEN
EXECUTE IMMEDIATE 'select count(*) from ' ||p_part_table_owner||'.' || rec.table_name || ' partition(' || rec.partition_name || ')' INTO l_temp_var;
l_retVal := l_retVal || l_temp_var || ',' ;
l_partition_counter := l_partition_counter+1;
ELSE
EXIT;
END CASE;
END LOOP;
END CASE;
ELSE -- list of partitions delimited with ","
SELECT column_value
BULK COLLECT
INTO l_chartab
FROM TABLE(tools.list2table(p_partitions));
CASE p_from_statistic
WHEN 'Y' THEN
FOR i IN 1 .. l_chartab.COUNT LOOP
FOR rec IN cs3 (p_part_table_owner,p_part_table_name,l_chartab(i)) LOOP
l_retVal := l_retVal || rec.num_rows || ',';
END LOOP;
END LOOP;
ELSE
FOR i IN 1 .. l_chartab.COUNT LOOP
EXECUTE IMMEDIATE 'select count(*) from ' ||p_part_table_owner||'.' || p_part_table_name || ' partition(' || l_chartab(i) || ') ' INTO l_temp_var;
l_retVal := l_retVal || l_temp_var || ',';
END LOOP;
END CASE;
END CASE;
DBMS_SESSION.FREE_UNUSED_USER_MEMORY;
return substr(l_retVal,1,(Length(l_retVal)-1));
END recs_in_partition;
--
FUNCTION running_sum_with_reset(
p_rownum NUMBER,
p_value NUMBER,
p_break_limit NUMBER,
p_reset_value NUMBER DEFAULT 0
) RETURN NUMBER
IS
BEGIN
IF p_rownum = 1 THEN
g_sum := p_value;
ELSE
g_sum := g_sum + p_value;
END IF;
--
IF g_sum >= p_break_limit THEN
g_sum := p_reset_value;
END IF;
--
RETURN g_sum;
END running_sum_with_reset;
FUNCTION running_sum_with_reset(
p_rownum NUMBER,
p_value NUMBER,
p_break_limit NUMBER,
p_reset_value NUMBER,
p_max_percentage NUMBER
) RETURN NUMBER
IS
BEGIN
IF p_rownum = 1 THEN
-- assign only ones -- speed!
g_sum := p_value;
g_max_treshold := p_break_limit * p_max_percentage;
ELSE
g_sum := g_sum + p_value;
END IF;
--
IF (g_sum >= g_max_treshold ) THEN
g_sum := p_reset_value;
END IF;
--
RETURN g_sum;
END running_sum_with_reset;
END partition_tools;
/
In this blog I'll explain just first functionality, because for second one I'll create additional blog.
partition_tools.recs_in_partition
p_partitions parameter define range of partition table which should be analyzed. It may have three kind of values:- ALL-means all partitions
- 'x,y'-where x and y are numbers which defines x=partition_position and y=number of partitions from x (range defined with numbers)...i.e. '10,10'
- 'a,b,c,...x)' comma separated list of partition names i.e. 'FUTURE_COST_P01310100,FUTURE_COST_P01310147'
- 'N' (default)-count(*), takes more time but it's fully accurate
- 'Y' (default)-num_rows from all_tab_partitions, may be inaccurate in lack of statistic
Procedure
Here is explanation of procedure, which seems to me self explicable examples. ALL parameter in action:
set serveroutput on size 1000000;
exec tools.partition_tools.recs_in_partiton ('ALL', 'RMS','FUTURE_COST2');
result is here (hidden because of complexity):
FUTURE_COST_P01310100= 62688 rows FUTURE_COST_P01310147= 59039 rows FUTURE_COST_P01310472= 64983 rows FUTURE_COST_P01310670= 53864 rows FUTURE_COST_P01310710= 63665 rows FUTURE_COST_P01310866= 45531 rows FUTURE_COST_P01310976= 64812 rows FUTURE_COST_P01311347= 64988 rows FUTURE_COST_P01318017= 64572 rows FUTURE_COST_P01400049= 65053 rows FUTURE_COST_P01400081= 47488 rows FUTURE_COST_P01400101= 65048 rows FUTURE_COST_P01400318= 64828 rows FUTURE_COST_P01400955= 58633 rows FUTURE_COST_P01401572= 54898 rows FUTURE_COST_P01401747= 61498 rows FUTURE_COST_P01401776= 27070 rows FUTURE_COST_P01401925= 60750 rows FUTURE_COST_P01402186= 63320 rows FUTURE_COST_P01402681= 60469 rows FUTURE_COST_P01403009= 64484 rows FUTURE_COST_P01405646= 54671 rows FUTURE_COST_P01405772= 43056 rows FUTURE_COST_P01407876= 64162 rows FUTURE_COST_P01409451= 57327 rows FUTURE_COST_P01410026= 52551 rows FUTURE_COST_P01410068= 57736 rows FUTURE_COST_P01410076= 55239 rows FUTURE_COST_P01410096= 64189 rows FUTURE_COST_P01410157= 56462 rows FUTURE_COST_P01410437= 62708 rows FUTURE_COST_P01410754= 65124 rows FUTURE_COST_P01411106= 63956 rows FUTURE_COST_P01411533= 64615 rows FUTURE_COST_P01411575= 48245 rows FUTURE_COST_P01411805= 57494 rows FUTURE_COST_P01413000= 54538 rows FUTURE_COST_P01413435= 63114 rows FUTURE_COST_P01414585= 60594 rows FUTURE_COST_P01415020= 60899 rows FUTURE_COST_P01415073= 64938 rows FUTURE_COST_P01465029= 64885 rows FUTURE_COST_P01471561= 57425 rows FUTURE_COST_P01480212= 64270 rows FUTURE_COST_P01490071= 61525 rows FUTURE_COST_P01490207= 65108 rows FUTURE_COST_P01490571= 62466 rows FUTURE_COST_P01491261= 57654 rows FUTURE_COST_P01491658= 63460 rows FUTURE_COST_P01495137= 64811 rows FUTURE_COST_P01499951= 64852 rows FUTURE_COST_P01500540= 65072 rows FUTURE_COST_P01506016= 64507 rows FUTURE_COST_P01516018= 65127 rows FUTURE_COST_P01520999= 62987 rows FUTURE_COST_P01530158= 61611 rows FUTURE_COST_P01550509= 64150 rows FUTURE_COST_P01551129= 65108 rows FUTURE_COST_P01560314= 64003 rows FUTURE_COST_P01570173= 64763 rows FUTURE_COST_P01570909= 62249 rows FUTURE_COST_P01571119= 58721 rows FUTURE_COST_P01580211= 59372 rows FUTURE_COST_P01590427= 65138 rows FUTURE_COST_P01630415= 64200 rows FUTURE_COST_P01640222= 64377 rows FUTURE_COST_P01640558= 64735 rows FUTURE_COST_P01641066= 56771 rows FUTURE_COST_P01641662= 65005 rows FUTURE_COST_P01642175= 58755 rows FUTURE_COST_P01642186= 64015 rows FUTURE_COST_P01645050= 60236 rows FUTURE_COST_P01645057= 56436 rows FUTURE_COST_P01647049= 63996 rows FUTURE_COST_P02000016= 65152 rows FUTURE_COST_P02000050= 64406 rows FUTURE_COST_P02000085= 64034 rows FUTURE_COST_P02000127= 64945 rows FUTURE_COST_P02000165= 64327 rows FUTURE_COST_P02000199= 63884 rows FUTURE_COST_P02000246= 63999 rows FUTURE_COST_P02000298= 63210 rows FUTURE_COST_P02016375= 65116 rows FUTURE_COST_P02018139= 52749 rows FUTURE_COST_P02019021= 65181 rows FUTURE_COST_P02020582= 60958 rows FUTURE_COST_P02024385= 60334 rows FUTURE_COST_P02024461= 59632 rows FUTURE_COST_P02024474= 63306 rows FUTURE_COST_P02030066= 57158 rows FUTURE_COST_P02033172= 60593 rows FUTURE_COST_P02034493= 57347 rows FUTURE_COST_P02034524= 59212 rows FUTURE_COST_P02036480= 55246 rows FUTURE_COST_P02036546= 60027 rows FUTURE_COST_P02038050= 65121 rows FUTURE_COST_P02039238= 64334 rows FUTURE_COST_P02039608= 65035 rows FUTURE_COST_P02044187= 61139 rows FUTURE_COST_P02044220= 31682 rows FUTURE_COST_P02044269= 65046 rows FUTURE_COST_P02044317= 59506 rows FUTURE_COST_P02048427= 63321 rows FUTURE_COST_P02048523= 64024 rows FUTURE_COST_P02050951= 56445 rows FUTURE_COST_P02052991= 64266 rows FUTURE_COST_P02053638= 53982 rows FUTURE_COST_P02053791= 63437 rows FUTURE_COST_P02053863= 57101 rows FUTURE_COST_P02053911= 52686 rows FUTURE_COST_P02055093= 58965 rows FUTURE_COST_P02055427= 65135 rows FUTURE_COST_P02100610= 58958 rows FUTURE_COST_P02103000= 64929 rows FUTURE_COST_P02103168= 62685 rows FUTURE_COST_P02160058= 60984 rows FUTURE_COST_P02160317= 63145 rows FUTURE_COST_P02160874= 64482 rows FUTURE_COST_P02161114= 60726 rows FUTURE_COST_P02164313= 65021 rows FUTURE_COST_P02166664= 60916 rows FUTURE_COST_P02169533= 63571 rows FUTURE_COST_P02180313= 64661 rows FUTURE_COST_P02190138= 64349 rows FUTURE_COST_P02190355= 61670 rows FUTURE_COST_P02191045= 64191 rows FUTURE_COST_P02193592= 65089 rows FUTURE_COST_P02195129= 59824 rows FUTURE_COST_P02195487= 61634 rows FUTURE_COST_P02197068= 64973 rows FUTURE_COST_P02197556= 55630 rows FUTURE_COST_P02197789= 64252 rows FUTURE_COST_P02198000= 60642 rows FUTURE_COST_P02198570= 64540 rows FUTURE_COST_P02198859= 61879 rows FUTURE_COST_P02199460= 64279 rows FUTURE_COST_P02200074= 63905 rows FUTURE_COST_P02202048= 54359 rows FUTURE_COST_P02202141= 63080 rows FUTURE_COST_P02210243= 64291 rows FUTURE_COST_P02230108= 63907 rows FUTURE_COST_P02230426= 62159 rows FUTURE_COST_P02231012= 63664 rows FUTURE_COST_P02233988= 62282 rows FUTURE_COST_P02234024= 62264 rows FUTURE_COST_P02320022= 63729 rows FUTURE_COST_P02320982= 61925 rows FUTURE_COST_P02324049= 51847 rows FUTURE_COST_P02324214= 33123 rows FUTURE_COST_P02329035= 61707 rows FUTURE_COST_P02329055= 63940 rows FUTURE_COST_P02330097= 63742 rows FUTURE_COST_P02330670= 65136 rows FUTURE_COST_P02330941= 64587 rows FUTURE_COST_P02331098= 58149 rows FUTURE_COST_P02331182= 61313 rows FUTURE_COST_P02331227= 59528 rows FUTURE_COST_P02331243= 65047 rows FUTURE_COST_P02334070= 62334 rows FUTURE_COST_P02334105= 26048 rows FUTURE_COST_P02334114= 63922 rows FUTURE_COST_P02334192= 65018 rows FUTURE_COST_P02334248= 59577 rows FUTURE_COST_P02334291= 65052 rows FUTURE_COST_P02334305= 65169 rows FUTURE_COST_P02334649= 62288 rows FUTURE_COST_P02334692= 64989 rows FUTURE_COST_P02350060= 57718 rows FUTURE_COST_P02350635= 64826 rows FUTURE_COST_P02350952= 51014 rows FUTURE_COST_P02351153= 59166 rows FUTURE_COST_P02351378= 64534 rows FUTURE_COST_P02351413= 62757 rows FUTURE_COST_P02351432= 64917 rows FUTURE_COST_P02360015= 64333 rows FUTURE_COST_P02360031= 59455 rows FUTURE_COST_P02361437= 64365 rows FUTURE_COST_P02361569= 61518 rows FUTURE_COST_P02370042= 63195 rows FUTURE_COST_P02370484= 63446 rows FUTURE_COST_P02371057= 64487 rows FUTURE_COST_P02371190= 63574 rows FUTURE_COST_P02371545= 61436 rows FUTURE_COST_P02371643= 64401 rows FUTURE_COST_P02371689= 64802 rows FUTURE_COST_P02373388= 65144 rows FUTURE_COST_P02373515= 62695 rows FUTURE_COST_P02373596= 65193 rows FUTURE_COST_P02373673= 65142 rows FUTURE_COST_P02373752= 65161 rows FUTURE_COST_P02373819= 62277 rows FUTURE_COST_P02373866= 64974 rows FUTURE_COST_P02390054= 59603 rows FUTURE_COST_P02390943= 53738 rows FUTURE_COST_P02398927= 61621 rows FUTURE_COST_P02398939= 26544 rows FUTURE_COST_P02398953= 62125 rows FUTURE_COST_P02400067= 58418 rows FUTURE_COST_P02401110= 64357 rows FUTURE_COST_P02402389= 54746 rows FUTURE_COST_P02403738= 64883 rows FUTURE_COST_P02404064= 58518 rows FUTURE_COST_P02404264= 61868 rows FUTURE_COST_P02404343= 65134 rows FUTURE_COST_P02410037= 59762 rows FUTURE_COST_P02412502= 61745 rows FUTURE_COST_P02420374= 65175 rows FUTURE_COST_P02434234= 58802 rows FUTURE_COST_P02435423= 64919 rows FUTURE_COST_P02435538= 62384 rows FUTURE_COST_P02451396= 62768 rows FUTURE_COST_P02481558= 64855 rows FUTURE_COST_P02510669= 64243 rows FUTURE_COST_P02520864= 65167 rows FUTURE_COST_P03010028= 46661 rows FUTURE_COST_P03010068= 46660 rows FUTURE_COST_P03010099= 46379 rows FUTURE_COST_P03010523= 61650 rows FUTURE_COST_P03011099= 60280 rows FUTURE_COST_P03012134= 60134 rows FUTURE_COST_P03015515= 39126 rows FUTURE_COST_P03019119= 64955 rows FUTURE_COST_P03019126= 61711 rows FUTURE_COST_P03020152= 64764 rows FUTURE_COST_P03020305= 61703 rows FUTURE_COST_P03020815= 64470 rows FUTURE_COST_P03021154= 50542 rows FUTURE_COST_P03021509= 65172 rows FUTURE_COST_P03021807= 60792 rows FUTURE_COST_P03022519= 57913 rows FUTURE_COST_P03023632= 65191 rows FUTURE_COST_P03030019= 61705 rows FUTURE_COST_P03040039= 57701 rows FUTURE_COST_P03041225= 64922 rows FUTURE_COST_P03063930= 65029 rows FUTURE_COST_P03070244= 64286 rows FUTURE_COST_P03070781= 62558 rows FUTURE_COST_P03071689= 64331 rows FUTURE_COST_P03080197= 64748 rows FUTURE_COST_P03082001= 65172 rows FUTURE_COST_P03120013= 57778 rows FUTURE_COST_P03120084= 63071 rows FUTURE_COST_P03120398= 64864 rows FUTURE_COST_P03130061= 65090 rows FUTURE_COST_P03130540= 64902 rows FUTURE_COST_P03130741= 65167 rows FUTURE_COST_P03131126= 63920 rows FUTURE_COST_P03131475= 46589 rows FUTURE_COST_P03140014= 63558 rows FUTURE_COST_P03140033= 60399 rows FUTURE_COST_P03140121= 62307 rows FUTURE_COST_P03140285= 63455 rows FUTURE_COST_P03140420= 64273 rows FUTURE_COST_P03140535= 61755 rows FUTURE_COST_P03140893= 65115 rows FUTURE_COST_P03141209= 62496 rows FUTURE_COST_P03141291= 64407 rows FUTURE_COST_P03142020= 61920 rows FUTURE_COST_P03142663= 64284 rows FUTURE_COST_P03145075= 64397 rows FUTURE_COST_P03148047= 64959 rows FUTURE_COST_P03150290= 65179 rows FUTURE_COST_P03160062= 64185 rows FUTURE_COST_P03160268= 52911 rows FUTURE_COST_P03160285= 62047 rows FUTURE_COST_P03160760= 63940 rows FUTURE_COST_P03160957= 65114 rows FUTURE_COST_P03162916= 62135 rows FUTURE_COST_P03163559= 64829 rows FUTURE_COST_P03164131= 64830 rows FUTURE_COST_P03167049= 61301 rows FUTURE_COST_P03167512= 56056 rows FUTURE_COST_P03170365= 64241 rows FUTURE_COST_P03170659= 58210 rows FUTURE_COST_P03172249= 64450 rows FUTURE_COST_P03180015= 62129 rows FUTURE_COST_P03180171= 58585 rows FUTURE_COST_P03182016= 64297 rows FUTURE_COST_P03210009= 58388 rows FUTURE_COST_P03210094= 63820 rows FUTURE_COST_P03210386= 59452 rows FUTURE_COST_P03220065= 53981 rows FUTURE_COST_P03250931= 64527 rows FUTURE_COST_P03251709= 63179 rows FUTURE_COST_P03280154= 64533 rows FUTURE_COST_P04010004= 64876 rows FUTURE_COST_P04010059= 65109 rows FUTURE_COST_P04010235= 62215 rows FUTURE_COST_P04010841= 64793 rows FUTURE_COST_P04011681= 64735 rows FUTURE_COST_P04012621= 65145 rows FUTURE_COST_P04014287= 65168 rows FUTURE_COST_P04015169= 65079 rows FUTURE_COST_P04015686= 64033 rows FUTURE_COST_P04015771= 47218 rows FUTURE_COST_P04015773= 55559 rows FUTURE_COST_P04015825= 61269 rows FUTURE_COST_P04016131= 65095 rows FUTURE_COST_P04016338= 64580 rows FUTURE_COST_P04016497= 61824 rows FUTURE_COST_P04019736= 56222 rows FUTURE_COST_P04019978= 64942 rows FUTURE_COST_P04020468= 63819 rows FUTURE_COST_P04020476= 38453 rows FUTURE_COST_P04021030= 65051 rows FUTURE_COST_P04022141= 65147 rows FUTURE_COST_P04022591= 60558 rows FUTURE_COST_P04023834= 65001 rows FUTURE_COST_P04024486= 65183 rows FUTURE_COST_P04024929= 64934 rows FUTURE_COST_P04025157= 64888 rows FUTURE_COST_P04025328= 64246 rows FUTURE_COST_P04025513= 65182 rows FUTURE_COST_P04027594= 65018 rows FUTURE_COST_P04028124= 60737 rows FUTURE_COST_P04029192= 65064 rows FUTURE_COST_P04030001= 61864 rows FUTURE_COST_P04030101= 64955 rows FUTURE_COST_P04030487= 59399 rows FUTURE_COST_P04030973= 64264 rows FUTURE_COST_P04031817= 58929 rows FUTURE_COST_P04039526= 64380 rows FUTURE_COST_P04050176= 65153 rows FUTURE_COST_P04050183= 65058 rows FUTURE_COST_P04050189= 63563 rows FUTURE_COST_P04050192= 45536 rows FUTURE_COST_P04050323= 41915 rows FUTURE_COST_P04050364= 64867 rows FUTURE_COST_P04050521= 65016 rows FUTURE_COST_P04050693= 63978 rows FUTURE_COST_P04050850= 65045 rows FUTURE_COST_P04051110= 61658 rows FUTURE_COST_P04051219= 65090 rows FUTURE_COST_P04051337= 61590 rows FUTURE_COST_P04051595= 61468 rows FUTURE_COST_P04051601= 64514 rows FUTURE_COST_P04052270= 63374 rows FUTURE_COST_P04057602= 51903 rows FUTURE_COST_P04057605= 54690 rows FUTURE_COST_P04060006= 61387 rows FUTURE_COST_P04060325= 65004 rows FUTURE_COST_P04065118= 64116 rows FUTURE_COST_P04070053= 63810 rows FUTURE_COST_P04070059= 54552 rows FUTURE_COST_P04070147= 59138 rows FUTURE_COST_P04070240= 56479 rows FUTURE_COST_P04070352= 51868 rows FUTURE_COST_P04070405= 54836 rows FUTURE_COST_P04070424= 57156 rows FUTURE_COST_P04070785= 64660 rows FUTURE_COST_P04071171= 65163 rows FUTURE_COST_P04071847= 62703 rows FUTURE_COST_P04072549= 64800 rows FUTURE_COST_P04074064= 64181 rows FUTURE_COST_P04090037= 64401 rows FUTURE_COST_P04090336= 65159 rows FUTURE_COST_P04091132= 64473 rows FUTURE_COST_P04091493= 63560 rows FUTURE_COST_P04091899= 64395 rows FUTURE_COST_P04100095= 64939 rows FUTURE_COST_P04100279= 63835 rows FUTURE_COST_P04100613= 63529 rows FUTURE_COST_P04102072= 63287 rows FUTURE_COST_P04110024= 64007 rows FUTURE_COST_P04121004= 64972 rows FUTURE_COST_P04130415= 63078 rows FUTURE_COST_P04140079= 64487 rows FUTURE_COST_P04140309= 60325 rows FUTURE_COST_P04140525= 63584 rows FUTURE_COST_P04140744= 62949 rows FUTURE_COST_P04140950= 64847 rows FUTURE_COST_P04141134= 64985 rows FUTURE_COST_P04141289= 62978 rows FUTURE_COST_P04141574= 65039 rows FUTURE_COST_P04141679= 61492 rows FUTURE_COST_P04141714= 41007 rows FUTURE_COST_P04141870= 63342 rows FUTURE_COST_P04142200= 57861 rows FUTURE_COST_P04142514= 63459 rows FUTURE_COST_P04142723= 62155 rows FUTURE_COST_P04143662= 61415 rows FUTURE_COST_P04144059= 64780 rows FUTURE_COST_P04146025= 55281 rows FUTURE_COST_P04147510= 64204 rows FUTURE_COST_P04149268= 64875 rows FUTURE_COST_P04149698= 64878 rows FUTURE_COST_P04150121= 37609 rows FUTURE_COST_P04150462= 63030 rows FUTURE_COST_P04150726= 58199 rows FUTURE_COST_P04150975= 57537 rows FUTURE_COST_P04151117= 58740 rows FUTURE_COST_P04151208= 62117 rows FUTURE_COST_P04151243= 63103 rows FUTURE_COST_P04151412= 63125 rows FUTURE_COST_P04151565= 62238 rows FUTURE_COST_P04152222= 53613 rows FUTURE_COST_P04152510= 60496 rows FUTURE_COST_P04155008= 64774 rows FUTURE_COST_P04160053= 64485 rows FUTURE_COST_P04160209= 60470 rows FUTURE_COST_P04160519= 62616 rows FUTURE_COST_P04160905= 65157 rows FUTURE_COST_P04161755= 60942 rows FUTURE_COST_P04162591= 63049 rows FUTURE_COST_P04162740= 64190 rows FUTURE_COST_P04163635= 65149 rows FUTURE_COST_P04169012= 57553 rows FUTURE_COST_P04170320= 62261 rows FUTURE_COST_P04170625= 64895 rows FUTURE_COST_P04170929= 64871 rows FUTURE_COST_P04171402= 60103 rows FUTURE_COST_P04172528= 60744 rows FUTURE_COST_P04173610= 64684 rows FUTURE_COST_P04180009= 64423 rows FUTURE_COST_P04180231= 65135 rows FUTURE_COST_P04180533= 62269 rows FUTURE_COST_P04180735= 60317 rows FUTURE_COST_P04181017= 63787 rows FUTURE_COST_P04181174= 65088 rows FUTURE_COST_P04182740= 64653 rows FUTURE_COST_P04183301= 59729 rows FUTURE_COST_P04185911= 65044 rows FUTURE_COST_P04190234= 65042 rows FUTURE_COST_P04190477= 64028 rows FUTURE_COST_P04191148= 61518 rows FUTURE_COST_P04191609= 61930 rows FUTURE_COST_P04191724= 59675 rows FUTURE_COST_P04192474= 61987 rows FUTURE_COST_P04193165= 62388 rows FUTURE_COST_P04195374= 63852 rows FUTURE_COST_P04199675= 64893 rows FUTURE_COST_P04200960= 64638 rows FUTURE_COST_P04207111= 63737 rows FUTURE_COST_P04210068= 65175 rows FUTURE_COST_P04210415= 58587 rows FUTURE_COST_P04210630= 47139 rows FUTURE_COST_P04210750= 65176 rows FUTURE_COST_P04210993= 57809 rows FUTURE_COST_P04211161= 59681 rows FUTURE_COST_P04211277= 56156 rows FUTURE_COST_P04211431= 64806 rows FUTURE_COST_P04211545= 62679 rows FUTURE_COST_P04211627= 62067 rows FUTURE_COST_P04211711= 64788 rows FUTURE_COST_P04211836= 65030 rows FUTURE_COST_P04211925= 59948 rows FUTURE_COST_P04212069= 61649 rows FUTURE_COST_P04212250= 65107 rows FUTURE_COST_P04212559= 63449 rows FUTURE_COST_P04213337= 63966 rows FUTURE_COST_P04217535= 64430 rows FUTURE_COST_P04219658= 64748 rows FUTURE_COST_P04220237= 64172 rows FUTURE_COST_P04220705= 64328 rows FUTURE_COST_P04221272= 60397 rows FUTURE_COST_P04221432= 62492 rows FUTURE_COST_P04221471= 60458 rows FUTURE_COST_P04225011= 64018 rows FUTURE_COST_P04230158= 62279 rows FUTURE_COST_P04240125= 64885 rows FUTURE_COST_P04250892= 62167 rows FUTURE_COST_P04251566= 64473 rows FUTURE_COST_P04280054= 64228 rows FUTURE_COST_P04280172= 64942 rows FUTURE_COST_P04280349= 65105 rows FUTURE_COST_P04280421= 65084 rows FUTURE_COST_P04331005= 62826 rows FUTURE_COST_P04360188= 64152 rows FUTURE_COST_P04410285= 64264 rows FUTURE_COST_P05012099= 64815 rows FUTURE_COST_P05030112= 65054 rows FUTURE_COST_P05030800= 64931 rows FUTURE_COST_P05031160= 65137 rows FUTURE_COST_P05031712= 65139 rows FUTURE_COST_P05032350= 63553 rows FUTURE_COST_P05035154= 65102 rows FUTURE_COST_P05040521= 64284 rows FUTURE_COST_P05072996= 64787 rows FUTURE_COST_P05080495= 29444 rows FUTURE_COST_P05080694= 63889 rows FUTURE_COST_P05081015= 63412 rows FUTURE_COST_P05081781= 64472 rows FUTURE_COST_P05082601= 63688 rows FUTURE_COST_P05085543= 65190 rows FUTURE_COST_P05089534= 61245 rows FUTURE_COST_P05090431= 65190 rows FUTURE_COST_P05092965= 65153 rows FUTURE_COST_P05097127= 64165 rows FUTURE_COST_P05102969= 64925 rows FUTURE_COST_P05111067= 65182 rows FUTURE_COST_P05121788= 65169 rows FUTURE_COST_P05130100= 65188 rows FUTURE_COST_P05182346= 61441 rows FUTURE_COST_P05182951= 63354 rows FUTURE_COST_P05183754= 65153 rows FUTURE_COST_P05184704= 65165 rows FUTURE_COST_P05210348= 64246 rows FUTURE_COST_P05310222= 64797 rows FUTURE_COST_P05311934= 64657 rows FUTURE_COST_P05313685= 63425 rows FUTURE_COST_P05315529= 64616 rows FUTURE_COST_P05354984= 64625 rows FUTURE_COST_P05411074= 64192 rows FUTURE_COST_P05417551= 64848 rows FUTURE_COST_P05420828= 65193 rows FUTURE_COST_P05422496= 65168 rows FUTURE_COST_P05441402= 65188 rows FUTURE_COST_P05441652= 64465 rows FUTURE_COST_P05443032= 64320 rows FUTURE_COST_P05443102= 64441 rows FUTURE_COST_P05443156= 64143 rows FUTURE_COST_P05447552= 63697 rows FUTURE_COST_P05447613= 65104 rows FUTURE_COST_P05448000= 64769 rows FUTURE_COST_P05448064= 64413 rows FUTURE_COST_P05448150= 64733 rows FUTURE_COST_P05448324= 64156 rows FUTURE_COST_P05448410= 65021 rows FUTURE_COST_P05448612= 64563 rows FUTURE_COST_P05448806= 64359 rows FUTURE_COST_P05448878= 64611 rows FUTURE_COST_P05448946= 64154 rows FUTURE_COST_P05449020= 64844 rows FUTURE_COST_P05510412= 64365 rows FUTURE_COST_P05520609= 63640 rows FUTURE_COST_P05570137= 65020 rows FUTURE_COST_P05610041= 65189 rows FUTURE_COST_P05670634= 64858 rows FUTURE_COST_P05672114= 65072 rows FUTURE_COST_P05701671= 65173 rows FUTURE_COST_P05702404= 65112 rows FUTURE_COST_P05702577= 64993 rows FUTURE_COST_P05702724= 65012 rows FUTURE_COST_P05711615= 65186 rows FUTURE_COST_P05772710= 65179 rows FUTURE_COST_P05773616= 64914 rows FUTURE_COST_P05773764= 64215 rows FUTURE_COST_P05774512= 65082 rows FUTURE_COST_P05775689= 64768 rows FUTURE_COST_P05781000= 65176 rows FUTURE_COST_P05811735= 65154 rows FUTURE_COST_P05813268= 65178 rows FUTURE_COST_P05813594= 64191 rows FUTURE_COST_P05817542= 65184 rows FUTURE_COST_P06013048= 64802 rows FUTURE_COST_P06014921= 65180 rows FUTURE_COST_P06021876= 65173 rows FUTURE_COST_P06032338= 65188 rows FUTURE_COST_P06050100= 64750 rows FUTURE_COST_P06081602= 64680 rows FUTURE_COST_P06100990= 64545 rows FUTURE_COST_P06101332= 64832 rows FUTURE_COST_P06112574= 64687 rows FUTURE_COST_P06143028= 64906 rows FUTURE_COST_P06152038= 65180 rows FUTURE_COST_P06172974= 65162 rows FUTURE_COST_P06183118= 64610 rows FUTURE_COST_P06193549= 65180 rows FUTURE_COST_P06201661= 65017 rows FUTURE_COST_P06301055= 64950 rows FUTURE_COST_P06462238= 65068 rows FUTURE_COST_P06465267= 64979 rows FUTURE_COST_P06466417= 64539 rows FUTURE_COST_P06466839= 64946 rows FUTURE_COST_P06467047= 64484 rows FUTURE_COST_P06467207= 65084 rows FUTURE_COST_P06467373= 64898 rows FUTURE_COST_P06480953= 64856 rows FUTURE_COST_P06481431= 65088 rows FUTURE_COST_P06500031= 55061 rows FUTURE_COST_P06500235= 65132 rows FUTURE_COST_P06500278= 59955 rows FUTURE_COST_P06500659= 61236 rows FUTURE_COST_P06500832= 61295 rows FUTURE_COST_P06501050= 58640 rows FUTURE_COST_P06501367= 59529 rows FUTURE_COST_P06502639= 61825 rows FUTURE_COST_P06504148= 65163 rows FUTURE_COST_P06510032= 53003 rows FUTURE_COST_P06510167= 59408 rows FUTURE_COST_P06510607= 62574 rows FUTURE_COST_P06511388= 63143 rows FUTURE_COST_P06513845= 59111 rows FUTURE_COST_P06519005= 63569 rows FUTURE_COST_P06520174= 63693 rows FUTURE_COST_P06520352= 62372 rows FUTURE_COST_P06520411= 57020 rows FUTURE_COST_P06520549= 55735 rows FUTURE_COST_P06520755= 63139 rows FUTURE_COST_P06520828= 65124 rows FUTURE_COST_P06520987= 64442 rows FUTURE_COST_P06521093= 64017 rows FUTURE_COST_P06521300= 64820 rows FUTURE_COST_P06521368= 65139 rows FUTURE_COST_P06521418= 64408 rows FUTURE_COST_P06521656= 58696 rows FUTURE_COST_P06521700= 57489 rows FUTURE_COST_P06522719= 65189 rows FUTURE_COST_P06524211= 65031 rows FUTURE_COST_P06524230= 55468 rows FUTURE_COST_P06525230= 64206 rows FUTURE_COST_P06526186= 59531 rows FUTURE_COST_P06529026= 64953 rows FUTURE_COST_P06530155= 61836 rows FUTURE_COST_P06530299= 60152 rows FUTURE_COST_P06530374= 65085 rows FUTURE_COST_P06530559= 58869 rows FUTURE_COST_P06530694= 65175 rows FUTURE_COST_P06531193= 62967 rows FUTURE_COST_P06537553= 59052 rows FUTURE_COST_P06540215= 61635 rows FUTURE_COST_P06540387= 57894 rows FUTURE_COST_P06540476= 64082 rows FUTURE_COST_P06540610= 55769 rows FUTURE_COST_P06540787= 64400 rows FUTURE_COST_P06541076= 64943 rows FUTURE_COST_P06541426= 63148 rows FUTURE_COST_P06542047= 63940 rows FUTURE_COST_P06542799= 62018 rows FUTURE_COST_P06543379= 64389 rows FUTURE_COST_P06544288= 64840 rows FUTURE_COST_P06544364= 65129 rows FUTURE_COST_P06548066= 63618 rows FUTURE_COST_P06550080= 62139 rows FUTURE_COST_P06550302= 61193 rows FUTURE_COST_P06550532= 62791 rows FUTURE_COST_P06550654= 64970 rows FUTURE_COST_P06551143= 63037 rows FUTURE_COST_P06552438= 65040 rows FUTURE_COST_P06552590= 63084 rows FUTURE_COST_P06552624= 59656 rows FUTURE_COST_P06555059= 61916 rows FUTURE_COST_P06555347= 65155 rows FUTURE_COST_P06560148= 60895 rows FUTURE_COST_P06560302= 64692 rows FUTURE_COST_P06560937= 60976 rows FUTURE_COST_P06562093= 64559 rows FUTURE_COST_P06565041= 62964 rows FUTURE_COST_P06574421= 65159 rows FUTURE_COST_P06581417= 65014 rows FUTURE_COST_P06583838= 65127 rows FUTURE_COST_P06586234= 65054 rows FUTURE_COST_P06587188= 65109 rows FUTURE_COST_P06587870= 65008 rows FUTURE_COST_P06588455= 65143 rows FUTURE_COST_P06588902= 65159 rows FUTURE_COST_P06589293= 65125 rows FUTURE_COST_P06589805= 65157 rows FUTURE_COST_P06590158= 59756 rows FUTURE_COST_P06590439= 65182 rows FUTURE_COST_P06591125= 64595 rows FUTURE_COST_P06591574= 64991 rows FUTURE_COST_P06592083= 63698 rows FUTURE_COST_P06592271= 64662 rows FUTURE_COST_P06592661= 59152 rows FUTURE_COST_P06593031= 59835 rows FUTURE_COST_P06593697= 64856 rows FUTURE_COST_P06595748= 65183 rows FUTURE_COST_P06596980= 62445 rows FUTURE_COST_P06600056= 57497 rows FUTURE_COST_P06600293= 65113 rows FUTURE_COST_P06601058= 65015 rows FUTURE_COST_P06601329= 61961 rows FUTURE_COST_P06602617= 64600 rows FUTURE_COST_P06615049= 64838 rows FUTURE_COST_P06623634= 64994 rows FUTURE_COST_P06630019= 62133 rows FUTURE_COST_P06633081= 60691 rows FUTURE_COST_P07000267= 64832 rows FUTURE_COST_P07000862= 64193 rows FUTURE_COST_P07000892= 61969 rows FUTURE_COST_P07000907= 58880 rows FUTURE_COST_P07000913= 60814 rows FUTURE_COST_P07001155= 65123 rows FUTURE_COST_P07020059= 64602 rows FUTURE_COST_P07040008= 64741 rows FUTURE_COST_P07040319= 64627 rows FUTURE_COST_P07050002= 62215 rows FUTURE_COST_P07052256= 59918 rows FUTURE_COST_P07060227= 52744 rows FUTURE_COST_P08010071= 62133 rows FUTURE_COST_P08010271= 65134 rows FUTURE_COST_P08010446= 65003 rows FUTURE_COST_P08010526= 57254 rows FUTURE_COST_P08010537= 62174 rows FUTURE_COST_P08010572= 50114 rows FUTURE_COST_P08010618= 58950 rows FUTURE_COST_P08010668= 60455 rows FUTURE_COST_P08010761= 62705 rows FUTURE_COST_P08010851= 57179 rows FUTURE_COST_P08011026= 64944 rows FUTURE_COST_P08011482= 65176 rows FUTURE_COST_P08011750= 64726 rows FUTURE_COST_P08012937= 65193 rows FUTURE_COST_P08013852= 61063 rows FUTURE_COST_P08014207= 63311 rows FUTURE_COST_P08014244= 59932 rows FUTURE_COST_P08015351= 64698 rows FUTURE_COST_P08016527= 55887 rows FUTURE_COST_P08020129= 40263 rows FUTURE_COST_P08020296= 63456 rows FUTURE_COST_P08020576= 58806 rows FUTURE_COST_P08021194= 63619 rows FUTURE_COST_P08021760= 62182 rows FUTURE_COST_P08025929= 52281 rows FUTURE_COST_P08025984= 55777 rows FUTURE_COST_P08030070= 64534 rows FUTURE_COST_P08030156= 64445 rows FUTURE_COST_P08030306= 65167 rows FUTURE_COST_P08030448= 55137 rows FUTURE_COST_P08030531= 61341 rows FUTURE_COST_P08030680= 65008 rows FUTURE_COST_P08030855= 60737 rows FUTURE_COST_P08031104= 64367 rows FUTURE_COST_P08031555= 62475 rows FUTURE_COST_P08033798= 65138 rows FUTURE_COST_P08035337= 61029 rows FUTURE_COST_P08035939= 64044 rows FUTURE_COST_P08036080= 64505 rows FUTURE_COST_P08041427= 63619 rows FUTURE_COST_P08070464= 64935 rows FUTURE_COST_P08080019= 63670 rows FUTURE_COST_P08080216= 62781 rows FUTURE_COST_P08081215= 63886 rows FUTURE_COST_P08082191= 62587 rows FUTURE_COST_P08090225= 60575 rows FUTURE_COST_P08091086= 53262 rows FUTURE_COST_P08091137= 51837 rows FUTURE_COST_P08091296= 60541 rows FUTURE_COST_P08092025= 63903 rows FUTURE_COST_P08130775= 65191 rows FUTURE_COST_P08163636= 63718 rows FUTURE_COST_P08303909= 64914 rows FUTURE_COST_P08402745= 65152 rows FUTURE_COST_P08560627= 65075 rows FUTURE_COST_P08810334= 64526 rows FUTURE_COST_P08813682= 65074 rows FUTURE_COST_P08830290= 63878 rows FUTURE_COST_P08930433= 65085 rows FUTURE_COST_P08931117= 64156 rows FUTURE_COST_P08931257= 64697 rows FUTURE_COST_P08944072= 64951 rows FUTURE_COST_P08950799= 65127 rows FUTURE_COST_P08962502= 65053 rows FUTURE_COST_P08963442= 64858 rows FUTURE_COST_P08963937= 65053 rows FUTURE_COST_P08972445= 64726 rows FUTURE_COST_P08973754= 64752 rows FUTURE_COST_P08974331= 65170 rows FUTURE_COST_P08974836= 64784 rows FUTURE_COST_P08980748= 65118 rows FUTURE_COST_P09500006= 17731 rows FUTURE_COST_P09500008= 61800 rows FUTURE_COST_P09500009= 67714 rows FUTURE_COST_P09500045= 38812 rows FUTURE_COST_P09500048= 52504 rows FUTURE_COST_P09500054= 64105 rows FUTURE_COST_P09500085= 49173 rows FUTURE_COST_P09500087= 43114 rows FUTURE_COST_P09500110= 62426 rows FUTURE_COST_P09500166= 64716 rows FUTURE_COST_P09500308= 61433 rows FUTURE_COST_P09500701= 61917 rows FUTURE_COST_P09501106= 65187 rows FUTURE_COST_P09510019= 59662 rows FUTURE_COST_P09510056= 65176 rows FUTURE_COST_P09510132= 64174 rows FUTURE_COST_P09510191= 58493 rows FUTURE_COST_P09510217= 60733 rows FUTURE_COST_P09510254= 63075 rows FUTURE_COST_P09510311= 64104 rows FUTURE_COST_P09510391= 62980 rows FUTURE_COST_P09510495= 65038 rows FUTURE_COST_P09510644= 64900 rows FUTURE_COST_P09510825= 64747 rows FUTURE_COST_P09511024= 64933 rows FUTURE_COST_P09511131= 65082 rows FUTURE_COST_P09520132= 65043 rows FUTURE_COST_P09520706= 60890 rows FUTURE_COST_P09521524= 65172 rows FUTURE_COST_P09521841= 65189 rows FUTURE_COST_P09531213= 65133 rows FUTURE_COST_P09610533= 65190 rows FUTURE_COST_P09611875= 65189 rows FUTURE_COST_P09614674= 64827 rows FUTURE_COST_P90000302= 65179 rows FUTURE_COST_P90001315= 65163 rows FUTURE_COST_P90002284= 65120 rows FUTURE_COST_P90003018= 65177 rows FUTURE_COST_P90003719= 65171 rows FUTURE_COST_P90004415= 65110 rows FUTURE_COST_P90005376= 65154 rows FUTURE_COST_P90006382= 65187 rows FUTURE_COST_P90007232= 65113 rows FUTURE_COST_P90008192= 65170 rows FUTURE_COST_P90009104= 65178 rows FUTURE_COST_P90009887= 65162 rows FUTURE_COST_P90010901= 65155 rows FUTURE_COST_P90012070= 65171 rows FUTURE_COST_P90013579= 65016 rows FUTURE_COST_P90014057= 64994 rows FUTURE_COST_P90014645= 65030 rows FUTURE_COST_P90015101= 65067 rows FUTURE_COST_P90015573= 65092 rows FUTURE_COST_P90015972= 65139 rows FUTURE_COST_P90016729= 65125 rows FUTURE_COST_P90017557= 65151 rows FUTURE_COST_P90018375= 65131 rows FUTURE_COST_P90019110= 65186 rows FUTURE_COST_P90019676= 65162 rows FUTURE_COST_P90020399= 65118 rows FUTURE_COST_P90021301= 65099 rows FUTURE_COST_P90022329= 65155 rows FUTURE_COST_P90023271= 65159 rows FUTURE_COST_P90024197= 65191 rows FUTURE_COST_P90025106= 65176 rows FUTURE_COST_P90026051= 65167 rows FUTURE_COST_P90027006= 65178 rows FUTURE_COST_P90027931= 65106 rows FUTURE_COST_P90028884= 65130 rows FUTURE_COST_P90029438= 64887 rows FUTURE_COST_P90029636= 64703 rows FUTURE_COST_P90029842= 64923 rows FUTURE_COST_P90030111= 65072 rows FUTURE_COST_P90030380= 65139 rows FUTURE_COST_P90030706= 64371 rows FUTURE_COST_P90030997= 64705 rows FUTURE_COST_P90031244= 64697 rows FUTURE_COST_P90031334= 56575 rows FUTURE_COST_P90031435= 61131 rows FUTURE_COST_P90031637= 64637 rows FUTURE_COST_P90031923= 64605 rows FUTURE_COST_P90032130= 64904 rows FUTURE_COST_P90032305= 65153 rows FUTURE_COST_P90032545= 63031 rows FUTURE_COST_P90032826= 64319 rows FUTURE_COST_P90033004= 65065 rows FUTURE_COST_P90033041= 62631 rows FUTURE_COST_P90033248= 65116 rows FUTURE_COST_P90033466= 65149 rows FUTURE_COST_P90033633= 63467 rows FUTURE_COST_P90033798= 64197 rows FUTURE_COST_P90033909= 61266 rows FUTURE_COST_P90034020= 64950 rows FUTURE_COST_P90034162= 65000 rows FUTURE_COST_P90034307= 65164 rows FUTURE_COST_P90034420= 63990 rows FUTURE_COST_P90034556= 62302 rows FUTURE_COST_P90034747= 65016 rows FUTURE_COST_P90034903= 64932 rows FUTURE_COST_P90035183= 65175 rows FUTURE_COST_P90035338= 59668 rows FUTURE_COST_P90035608= 63071 rows FUTURE_COST_P90035849= 64452 rows FUTURE_COST_P90036130= 65096 rows FUTURE_COST_P90036268= 65013 rows FUTURE_COST_P90036441= 64870 rows FUTURE_COST_P90036531= 57974 rows FUTURE_COST_P90036645= 64347 rows FUTURE_COST_P90036795= 65169 rows FUTURE_COST_P90036905= 65033 rows FUTURE_COST_P90037169= 64879 rows FUTURE_COST_P90037308= 65024 rows FUTURE_COST_P90037413= 62474 rows FUTURE_COST_P90037575= 65178 rows FUTURE_COST_P90037734= 64983 rows FUTURE_COST_P90037947= 65150 rows FUTURE_COST_P90038175= 65030 rows FUTURE_COST_P90038405= 65165 rows FUTURE_COST_P90038513= 65169 rows FUTURE_COST_P90038638= 58268 rows FUTURE_COST_P90038762= 60795 rows FUTURE_COST_P90038894= 64328 rows FUTURE_COST_P90039005= 65133 rows FUTURE_COST_P90039194= 62930 rows FUTURE_COST_P90039375= 64857 rows FUTURE_COST_P90039640= 60881 rows FUTURE_COST_P90039741= 65048 rows FUTURE_COST_P90039839= 63797 rows FUTURE_COST_P90040000= 65155 rows FUTURE_COST_P90040254= 64708 rows FUTURE_COST_P90040462= 62908 rows FUTURE_COST_P90040695= 63042 rows FUTURE_COST_P90041040= 65005 rows FUTURE_COST_P90041196= 65086 rows FUTURE_COST_P90041272= 54789 rows FUTURE_COST_P90041435= 65184 rows FUTURE_COST_P90041569= 65187 rows FUTURE_COST_P90041718= 62802 rows FUTURE_COST_P90041937= 65143 rows FUTURE_COST_P90042052= 65179 rows FUTURE_COST_P90042150= 42480 rows FUTURE_COST_P90042229= 65160 rows FUTURE_COST_P90042337= 65032 rows FUTURE_COST_P90042484= 65024 rows FUTURE_COST_P90042763= 64335 rows FUTURE_COST_P90043005= 65097 rows FUTURE_COST_P90043328= 64570 rows FUTURE_COST_P90043578= 63757 rows FUTURE_COST_P90043823= 59399 rows FUTURE_COST_P90044109= 65044 rows FUTURE_COST_P90044211= 57364 rows FUTURE_COST_P90044432= 65183 rows FUTURE_COST_P90044703= 65158 rows FUTURE_COST_P90044768= 63773 rows FUTURE_COST_P90044933= 63845 rows FUTURE_COST_P90045108= 63631 rows FUTURE_COST_P90045180= 64911 rows FUTURE_COST_P90045359= 64313 rows FUTURE_COST_P90045555= 64899 rows FUTURE_COST_P90045817= 64595 rows FUTURE_COST_P90045938= 44096 rows FUTURE_COST_P90046050= 64984 rows FUTURE_COST_P90046232= 64743 rows FUTURE_COST_P90046428= 65010 rows FUTURE_COST_P90046586= 63893 rows FUTURE_COST_P90046793= 65175 rows FUTURE_COST_P90047012= 63718 rows FUTURE_COST_P90047106= 60918 rows FUTURE_COST_P90047212= 64545 rows FUTURE_COST_P90047455= 65029 rows FUTURE_COST_P90047689= 64763 rows FUTURE_COST_P90047821= 63809 rows FUTURE_COST_P90048087= 65191 rows FUTURE_COST_P90048279= 65169 rows FUTURE_COST_P90048448= 64828 rows FUTURE_COST_P90048695= 64431 rows FUTURE_COST_P90048904= 64765 rows FUTURE_COST_P90049139= 64910 rows FUTURE_COST_P90049437= 64999 rows FUTURE_COST_P90049838= 65019 rows FUTURE_COST_P90050095= 64257 rows FUTURE_COST_P90050330= 64677 rows FUTURE_COST_P90050595= 64979 rows FUTURE_COST_P90050782= 63922 rows FUTURE_COST_P90050940= 64061 rows FUTURE_COST_P90051039= 62252 rows FUTURE_COST_P90051193= 63839 rows FUTURE_COST_P90051303= 64359 rows FUTURE_COST_P90051518= 64979 rows FUTURE_COST_P90051587= 65096 rows FUTURE_COST_P90051881= 64669 rows FUTURE_COST_P90052110= 63765 rows FUTURE_COST_P90052192= 64508 rows FUTURE_COST_P90052391= 65076 rows FUTURE_COST_P90052687= 54453 rows FUTURE_COST_P90052850= 64166 rows FUTURE_COST_P90053086= 64193 rows FUTURE_COST_P90053225= 61417 rows FUTURE_COST_P90053341= 64948 rows FUTURE_COST_P90053512= 61846 rows FUTURE_COST_P90053772= 65146 rows FUTURE_COST_P90054071= 65025 rows FUTURE_COST_P90054347= 64670 rows FUTURE_COST_P90054500= 44340 rows FUTURE_COST_P90054621= 63420 rows FUTURE_COST_P90054744= 58807 rows FUTURE_COST_P90054864= 64794 rows FUTURE_COST_P90055066= 64644 rows FUTURE_COST_P90055231= 60335 rows FUTURE_COST_P90055391= 65121 rows FUTURE_COST_P90055547= 64903 rows FUTURE_COST_P90055726= 65151 rows FUTURE_COST_P90055840= 59646 rows FUTURE_COST_P90055978= 64142 rows FUTURE_COST_P90056129= 64716 rows FUTURE_COST_P90056275= 63817 rows FUTURE_COST_P90056489= 65144 rows FUTURE_COST_P90056591= 63476 rows FUTURE_COST_P90056808= 64290 rows FUTURE_COST_P90056931= 64830 rows FUTURE_COST_P90057179= 64915 rows FUTURE_COST_P90057343= 65193 rows FUTURE_COST_P90057530= 64912 rows FUTURE_COST_P90057734= 64655 rows FUTURE_COST_P90057874= 62624 rows FUTURE_COST_P90057979= 63849 rows FUTURE_COST_P90058114= 64998 rows FUTURE_COST_P90058570= 64418 rows FUTURE_COST_P90058643= 65143 rows FUTURE_COST_P90058845= 60475 rows FUTURE_COST_P90059074= 65138 rows FUTURE_COST_P90059405= 61143 rows FUTURE_COST_P90059578= 64718 rows FUTURE_COST_P90059731= 65050 rows FUTURE_COST_P90059992= 64799 rows FUTURE_COST_P90060156= 64580 rows FUTURE_COST_P90060592= 65111 rows FUTURE_COST_P90060934= 63041 rows FUTURE_COST_P90061122= 64809 rows FUTURE_COST_P90061331= 63270 rows FUTURE_COST_P90061673= 64778 rows FUTURE_COST_P90061948= 63657 rows FUTURE_COST_P90062299= 65028 rows FUTURE_COST_P90062709= 65153 rows FUTURE_COST_P90063038= 64642 rows FUTURE_COST_P90063427= 65186 rows FUTURE_COST_P90063546= 61576 rows FUTURE_COST_P90063896= 63207 rows FUTURE_COST_P90064035= 59309 rows FUTURE_COST_P90064344= 65073 rows FUTURE_COST_P90064780= 63156 rows FUTURE_COST_P90065080= 63567 rows FUTURE_COST_P90065562= 65168 rows FUTURE_COST_P90066357= 65033 rows FUTURE_COST_P90066642= 65173 rows FUTURE_COST_P90067030= 65081 rows FUTURE_COST_P90067413= 63908 rows FUTURE_COST_P90067675= 63551 rows FUTURE_COST_P90068175= 65044 rows FUTURE_COST_P90068572= 65165 rows FUTURE_COST_P90068893= 65185 rows FUTURE_COST_P90069290= 64992 rows FUTURE_COST_P90069780= 64697 rows FUTURE_COST_P90070199= 64951 rows FUTURE_COST_P90070644= 64910 rows FUTURE_COST_P90071052= 64874 rows FUTURE_COST_P90071572= 64726 rows FUTURE_COST_P90072194= 63381 rows FUTURE_COST_P999999990= 0 rows PL/SQL procedure successfully completed.Range by numbers in action:
SQL> exec tools.partition_tools.recs_in_partiton ('1,1','RMS','FUTURE_COST2');
FUTURE_COST_P01310100= 62688 rows
PL/SQL procedure successfully completed.
SQL> exec tools.partition_tools.recs_in_partiton ('1,2','RMS','FUTURE_COST2');
FUTURE_COST_P01310100= 62688 rows
FUTURE_COST_P01310147= 59039 rows
PL/SQL procedure successfully completed.
SQL> exec tools.partition_tools.recs_in_partiton ('2,2','RMS','FUTURE_COST2');
FUTURE_COST_P01310147= 59039 rows
FUTURE_COST_P01310472= 64983 rows
PL/SQL procedure successfully completed.
SQL> set serveroutput on size 1000000;
SQL> exec tools.partition_tools.recs_in_partiton ('10,10', 'RMS','FUTURE_COST2');
FUTURE_COST_P01400049= 65053 rows
FUTURE_COST_P01400081= 47488 rows
FUTURE_COST_P01400101= 65048 rows
FUTURE_COST_P01400318= 64828 rows
FUTURE_COST_P01400955= 58633 rows
FUTURE_COST_P01401572= 54898 rows
FUTURE_COST_P01401747= 61498 rows
FUTURE_COST_P01401776= 27070 rows
FUTURE_COST_P01401925= 60750 rows
FUTURE_COST_P01402186= 63320 rows
PL/SQL procedure successfully completed.
partition list in action:
SQL> SQL> exec tools.partition_tools.recs_in_partition ('FUTURE_COST_P90061948,FUTURE_COST_P90062299,FUTURE_COST_P90062709,FUTURE_COST_P90063038,FUTURE_COST_P90063427,FUTURE_COST_P90063546,FUTURE_COST_P90063896,FUTURE_COST_P9
0064035,FUTURE_COST_P90064344,FUTURE_COST_P90064780,FUTURE_COST_P90065080,FUTURE_COST_P90065562,FUTURE_COST_P90066357,FUTURE_COST_P90066642','RMS','FUTURE_COST2');
FUTURE_COST_P90061948= 63657 rows
FUTURE_COST_P90062299= 65028 rows
FUTURE_COST_P90062709= 65153 rows
FUTURE_COST_P90063038= 64642 rows
FUTURE_COST_P90063427= 65186 rows
FUTURE_COST_P90063546= 61576 rows
FUTURE_COST_P90063896= 63207 rows
FUTURE_COST_P90064035= 59309 rows
FUTURE_COST_P90064344= 65073 rows
FUTURE_COST_P90064780= 63156 rows
FUTURE_COST_P90065080= 63567 rows
FUTURE_COST_P90065562= 65168 rows
FUTURE_COST_P90066357= 65033 rows
FUTURE_COST_P90066642= 65173 rows
PL/SQL procedure successfully completed.
Function
Function has the used in situation when you do not need text output but numbers which you'll use for further calculations. For an example calculating average etc. Here are examples that would explain that:
col min_v for a15;
col max_v for a15;
col avg_v for 9999999990D90;
col med_v for 9999999990D90;
col delta_v for 9999999990D90;
SELECT min(column_value) min_v, max(column_value) max_v, avg (cast (column_value as INTEGER)) avg_v, median (cast (column_value as INTEGER)) med_v,
ABS (avg (cast (column_value as INTEGER)) - median (cast (column_value as INTEGER))) delta_v
FROM TABLE(tools.list2table(tools.partition_tools.recs_in_partition('10,100', 'RMS','FUTURE_COST2','Y')));
MIN_V MAX_V AVG_V MED_V DELTA_V
--------------- --------------- -------------- -------------- --------------
27070 65181 60582.02 63162.00 2579.98
Real use of this is when you need to create partition with equal width of records in each, then median value should not differe too much from average.
Hope this helps someone.
Cheers!
