February 6, 2012 at 8:53 pm
Hi,
I am actually having some problem to improve the performance of this query:
INSERT INTO bigw.PL0_NEW_ALL (
BOOL0,
BOOL0_NUMTRUE,
BOOL0_TOTAL,
BOOL0_TRUEDATE,
BOOL0_TRUEVISIT,
BOOL1,
BOOL1_NUMTRUE,
BOOL1_TOTAL,
BOOL1_TRUEDATE,
BOOL1_TRUEVISIT,
BOOL2,
BOOL2_NUMTRUE,
BOOL2_TOTAL,
BOOL2_TRUEDATE,
BOOL2_TRUEVISIT,
BOOL3,
BOOL3_NUMTRUE,
BOOL3_TOTAL,
BOOL3_TRUEDATE,
BOOL3_TRUEVISIT,
BOOL4,
BOOL4_NUMTRUE,
BOOL4_TOTAL,
BOOL4_TRUEDATE,
BOOL4_TRUEVISIT,
BOOL5,
BOOL5_NUMTRUE,
BOOL5_TOTAL,
BOOL5_TRUEDATE,
BOOL5_TRUEVISIT,
BOOL6,
BOOL6_NUMTRUE,
BOOL6_TOTAL,
BOOL6_TRUEDATE,
BOOL6_TRUEVISIT,
BOOL7,
BOOL7_NUMTRUE,
BOOL7_TOTAL,
BOOL7_TRUEDATE,
BOOL7_TRUEVISIT,
BOOL8,
BOOL8_NUMTRUE,
BOOL8_TOTAL,
BOOL8_TRUEDATE,
BOOL8_TRUEVISIT,
BOOL9,
BOOL9_NUMTRUE,
BOOL9_TOTAL,
BOOL9_TRUEDATE,
BOOL9_TRUEVISIT,
BOOL10,
BOOL10_NUMTRUE,
BOOL10_TOTAL,
BOOL10_TRUEDATE,
BOOL10_TRUEVISIT,
BOOL11,
BOOL11_NUMTRUE,
BOOL11_TOTAL,
BOOL11_TRUEDATE,
BOOL11_TRUEVISIT,
BOOL12,
BOOL12_NUMTRUE,
BOOL12_TOTAL,
BOOL12_TRUEDATE,
BOOL12_TRUEVISIT,
BOOL13,
BOOL13_NUMTRUE,
BOOL13_TOTAL,
BOOL13_TRUEDATE,
BOOL13_TRUEVISIT,
BOOL14,
BOOL14_NUMTRUE,
BOOL14_TOTAL,
BOOL14_TRUEDATE,
BOOL14_TRUEVISIT,
BOOL15,
BOOL15_NUMTRUE,
BOOL15_TOTAL,
BOOL15_TRUEDATE,
BOOL15_TRUEVISIT,
BOOL16,
BOOL16_NUMTRUE,
BOOL16_TOTAL,
BOOL16_TRUEDATE,
BOOL16_TRUEVISIT,
BOOL17,
BOOL17_NUMTRUE,
BOOL17_TOTAL,
BOOL17_TRUEDATE,
BOOL17_TRUEVISIT,
BOOL18,
BOOL18_NUMTRUE,
BOOL18_TOTAL,
BOOL18_TRUEDATE,
BOOL18_TRUEVISIT,
BOOL19,
BOOL19_NUMTRUE,
BOOL19_TOTAL,
BOOL19_TRUEDATE,
BOOL19_TRUEVISIT,
BOOL20,
BOOL20_NUMTRUE,
BOOL20_TOTAL,
BOOL20_TRUEDATE,
BOOL20_TRUEVISIT,
BOOL21,
BOOL21_NUMTRUE,
BOOL21_TOTAL,
BOOL21_TRUEDATE,
BOOL21_TRUEVISIT,
BOOL22,
BOOL22_NUMTRUE,
BOOL22_TOTAL,
BOOL22_TRUEDATE,
BOOL22_TRUEVISIT,
BOOL23,
BOOL23_NUMTRUE,
BOOL23_TOTAL,
BOOL23_TRUEDATE,
BOOL23_TRUEVISIT,
BOOL24,
BOOL24_NUMTRUE,
BOOL24_TOTAL,
BOOL24_TRUEDATE,
BOOL24_TRUEVISIT,
BOOL25,
BOOL25_NUMTRUE,
BOOL25_TOTAL,
BOOL25_TRUEDATE,
BOOL25_TRUEVISIT,
BOOL26,
BOOL26_NUMTRUE,
BOOL26_TOTAL,
BOOL26_TRUEDATE,
BOOL26_TRUEVISIT,
BOOL27,
BOOL27_NUMTRUE,
BOOL27_TOTAL,
BOOL27_TRUEDATE,
BOOL27_TRUEVISIT,
BOOL28,
BOOL28_NUMTRUE,
BOOL28_TOTAL,
BOOL28_TRUEDATE,
BOOL28_TRUEVISIT,
BOOL29,
BOOL29_NUMTRUE,
BOOL29_TOTAL,
BOOL29_TRUEDATE,
BOOL29_TRUEVISIT,
BOOL30,
BOOL30_NUMTRUE,
BOOL30_TOTAL,
BOOL30_TRUEDATE,
BOOL30_TRUEVISIT,
BOOL31,
BOOL31_NUMTRUE,
BOOL31_TOTAL,
BOOL31_TRUEDATE,
BOOL31_TRUEVISIT,
BOOL32,
BOOL32_NUMTRUE,
BOOL32_TOTAL,
BOOL32_TRUEDATE,
BOOL32_TRUEVISIT,
BOOL33,
BOOL33_NUMTRUE,
BOOL33_TOTAL,
BOOL33_TRUEDATE,
BOOL33_TRUEVISIT,
BOOL34,
BOOL34_NUMTRUE,
BOOL34_TOTAL,
BOOL34_TRUEDATE,
BOOL34_TRUEVISIT,
BOOL35,
BOOL35_NUMTRUE,
BOOL35_TOTAL,
BOOL35_TRUEDATE,
BOOL35_TRUEVISIT,
BOOL36,
BOOL36_NUMTRUE,
BOOL36_TOTAL,
BOOL36_TRUEDATE,
BOOL36_TRUEVISIT,
BOOL37,
BOOL37_NUMTRUE,
BOOL37_TOTAL,
BOOL37_TRUEDATE,
BOOL37_TRUEVISIT,
BOOL38,
BOOL38_NUMTRUE,
BOOL38_TOTAL,
BOOL38_TRUEDATE,
BOOL38_TRUEVISIT,
BOOL39,
BOOL39_NUMTRUE,
BOOL39_TOTAL,
BOOL39_TRUEDATE,
BOOL39_TRUEVISIT,
BOOL40,
BOOL40_NUMTRUE,
BOOL40_TOTAL,
BOOL40_TRUEDATE,
BOOL40_TRUEVISIT,
BOOL41,
BOOL41_NUMTRUE,
BOOL41_TOTAL,
BOOL41_TRUEDATE,
BOOL41_TRUEVISIT,
BOOL42,
BOOL42_NUMTRUE,
BOOL42_TOTAL,
BOOL42_TRUEDATE,
BOOL42_TRUEVISIT,
BOOL43,
BOOL43_NUMTRUE,
BOOL43_TOTAL,
BOOL43_TRUEDATE,
BOOL43_TRUEVISIT,
BOOL44,
BOOL44_NUMTRUE,
BOOL44_TOTAL,
BOOL44_TRUEDATE,
BOOL44_TRUEVISIT,
BOOL45,
BOOL45_NUMTRUE,
BOOL45_TOTAL,
BOOL45_TRUEDATE,
BOOL45_TRUEVISIT,
BOOL46,
BOOL46_NUMTRUE,
BOOL46_TOTAL,
BOOL46_TRUEDATE,
BOOL46_TRUEVISIT,
BOOL47,
BOOL47_NUMTRUE,
BOOL47_TOTAL,
BOOL47_TRUEDATE,
BOOL47_TRUEVISIT,
BOOL48,
BOOL48_NUMTRUE,
BOOL48_TOTAL,
BOOL48_TRUEDATE,
BOOL48_TRUEVISIT,
BOOL49,
BOOL49_NUMTRUE,
BOOL49_TOTAL,
BOOL49_TRUEDATE,
BOOL49_TRUEVISIT,
BOOL50,
BOOL50_NUMTRUE,
BOOL50_TOTAL,
BOOL50_TRUEDATE,
BOOL50_TRUEVISIT,
BOOL51,
BOOL51_NUMTRUE,
BOOL51_TOTAL,
BOOL51_TRUEDATE,
BOOL51_TRUEVISIT,
BOOL52,
BOOL52_NUMTRUE,
BOOL52_TOTAL,
BOOL52_TRUEDATE,
BOOL52_TRUEVISIT,
BOOL53,
BOOL53_NUMTRUE,
BOOL53_TOTAL,
BOOL53_TRUEDATE,
BOOL53_TRUEVISIT,
BOOL54,
BOOL54_NUMTRUE,
BOOL54_TOTAL,
BOOL54_TRUEDATE,
BOOL54_TRUEVISIT,
BOOL55,
BOOL55_NUMTRUE,
BOOL55_TOTAL,
BOOL55_TRUEDATE,
BOOL55_TRUEVISIT,
BOOL56,
BOOL56_NUMTRUE,
BOOL56_TOTAL,
BOOL56_TRUEDATE,
BOOL56_TRUEVISIT,
BOOL57,
BOOL57_NUMTRUE,
BOOL57_TOTAL,
BOOL57_TRUEDATE,
BOOL57_TRUEVISIT,
BOOL58,
BOOL58_NUMTRUE,
BOOL58_TOTAL,
BOOL58_TRUEDATE,
BOOL58_TRUEVISIT,
BOOL59,
BOOL59_NUMTRUE,
BOOL59_TOTAL,
BOOL59_TRUEDATE,
BOOL59_TRUEVISIT,
BOOL60,
BOOL60_NUMTRUE,
BOOL60_TOTAL,
BOOL60_TRUEDATE,
BOOL60_TRUEVISIT,
BOOL61,
BOOL61_NUMTRUE,
BOOL61_TOTAL,
BOOL61_TRUEDATE,
BOOL61_TRUEVISIT,
BOOL62,
BOOL62_NUMTRUE,
BOOL62_TOTAL,
BOOL62_TRUEDATE,
BOOL62_TRUEVISIT,
BOOL63,
BOOL63_NUMTRUE,
BOOL63_TOTAL,
BOOL63_TRUEDATE,
BOOL63_TRUEVISIT,
BOOL64,
BOOL64_NUMTRUE,
BOOL64_TOTAL,
BOOL64_TRUEDATE,
BOOL64_TRUEVISIT,
BOOL65,
BOOL65_NUMTRUE,
BOOL65_TOTAL,
BOOL65_TRUEDATE,
BOOL65_TRUEVISIT,
BOOL66,
BOOL66_NUMTRUE,
BOOL66_TOTAL,
BOOL66_TRUEDATE,
BOOL66_TRUEVISIT,
BOOL67,
BOOL67_NUMTRUE,
BOOL67_TOTAL,
BOOL67_TRUEDATE,
BOOL67_TRUEVISIT,
BOOL68,
BOOL68_NUMTRUE,
BOOL68_TOTAL,
BOOL68_TRUEDATE,
BOOL68_TRUEVISIT,
BOOL69,
BOOL69_NUMTRUE,
BOOL69_TOTAL,
BOOL69_TRUEDATE,
BOOL69_TRUEVISIT,
BOOL70,
BOOL70_NUMTRUE,
BOOL70_TOTAL,
BOOL70_TRUEDATE,
BOOL70_TRUEVISIT,
BOOL71,
BOOL71_NUMTRUE,
BOOL71_TOTAL,
BOOL71_TRUEDATE,
BOOL71_TRUEVISIT,
BOOL72,
BOOL72_NUMTRUE,
BOOL72_TOTAL,
BOOL72_TRUEDATE,
BOOL72_TRUEVISIT,
BOOL73,
BOOL73_NUMTRUE,
BOOL73_TOTAL,
BOOL73_TRUEDATE,
BOOL73_TRUEVISIT,
BOOL74,
BOOL74_NUMTRUE,
BOOL74_TOTAL,
BOOL74_TRUEDATE,
BOOL74_TRUEVISIT,
BOOL75,
BOOL75_NUMTRUE,
BOOL75_TOTAL,
BOOL75_TRUEDATE,
BOOL75_TRUEVISIT,
BOOL76,
BOOL76_NUMTRUE,
BOOL76_TOTAL,
BOOL76_TRUEDATE,
BOOL76_TRUEVISIT,
BOOL77,
BOOL77_NUMTRUE,
BOOL77_TOTAL,
BOOL77_TRUEDATE,
BOOL77_TRUEVISIT,
BOOL78,
BOOL78_NUMTRUE,
BOOL78_TOTAL,
BOOL78_TRUEDATE,
BOOL78_TRUEVISIT,
BOOL79,
BOOL79_NUMTRUE,
BOOL79_TOTAL,
BOOL79_TRUEDATE,
BOOL79_TRUEVISIT,
BOOL80,
BOOL80_NUMTRUE,
BOOL80_TOTAL,
BOOL80_TRUEDATE,
BOOL80_TRUEVISIT,
BOOL81,
BOOL81_NUMTRUE,
BOOL81_TOTAL,
BOOL81_TRUEDATE,
BOOL81_TRUEVISIT,
BOOL82,
BOOL82_NUMTRUE,
BOOL82_TOTAL,
BOOL82_TRUEDATE,
BOOL82_TRUEVISIT,
BOOL83,
BOOL83_NUMTRUE,
BOOL83_TOTAL,
BOOL83_TRUEDATE,
BOOL83_TRUEVISIT,
BOOL84,
BOOL84_NUMTRUE,
BOOL84_TOTAL,
BOOL84_TRUEDATE,
BOOL84_TRUEVISIT,
BOOL85,
BOOL85_NUMTRUE,
BOOL85_TOTAL,
BOOL85_TRUEDATE,
BOOL85_TRUEVISIT,
BOOL86,
BOOL86_NUMTRUE,
BOOL86_TOTAL,
BOOL86_TRUEDATE,
BOOL86_TRUEVISIT,
BOOL87,
BOOL87_NUMTRUE,
BOOL87_TOTAL,
BOOL87_TRUEDATE,
BOOL87_TRUEVISIT,
BOOL88,
BOOL88_NUMTRUE,
BOOL88_TOTAL,
BOOL88_TRUEDATE,
BOOL88_TRUEVISIT,
BOOL89,
BOOL89_NUMTRUE,
BOOL89_TOTAL,
BOOL89_TRUEDATE,
BOOL89_TRUEVISIT,
BOOL90,
BOOL90_NUMTRUE,
BOOL90_TOTAL,
BOOL90_TRUEDATE,
BOOL90_TRUEVISIT,
BOOL91,
BOOL91_NUMTRUE,
BOOL91_TOTAL,
BOOL91_TRUEDATE,
BOOL91_TRUEVISIT,
BOOL92,
BOOL92_NUMTRUE,
BOOL92_TOTAL,
BOOL92_TRUEDATE,
BOOL92_TRUEVISIT,
BOOL93,
BOOL93_NUMTRUE,
BOOL93_TOTAL,
BOOL93_TRUEDATE,
BOOL93_TRUEVISIT,
BOOL94,
BOOL94_NUMTRUE,
BOOL94_TOTAL,
BOOL94_TRUEDATE,
BOOL94_TRUEVISIT,
BOOL95,
BOOL95_NUMTRUE,
BOOL95_TOTAL,
BOOL95_TRUEDATE,
BOOL95_TRUEVISIT,
BOOL96,
BOOL96_NUMTRUE,
BOOL96_TOTAL,
BOOL96_TRUEDATE,
BOOL96_TRUEVISIT,
BOOL97,
BOOL97_NUMTRUE,
BOOL97_TOTAL,
BOOL97_TRUEDATE,
BOOL97_TRUEVISIT,
BOOL98,
BOOL98_NUMTRUE,
BOOL98_TOTAL,
BOOL98_TRUEDATE,
BOOL98_TRUEVISIT,
BOOL99,
BOOL99_NUMTRUE,
BOOL99_TOTAL,
BOOL99_TRUEDATE,
BOOL99_TRUEVISIT,
BOOL100,
BOOL100_NUMTRUE,
BOOL100_TOTAL,
BOOL100_TRUEDATE,
BOOL100_TRUEVISIT,
BOOL101,
BOOL101_NUMTRUE,
BOOL101_TOTAL,
BOOL101_TRUEDATE,
BOOL101_TRUEVISIT,
BOOL102,
BOOL102_NUMTRUE,
BOOL102_TOTAL,
BOOL102_TRUEDATE,
BOOL102_TRUEVISIT,
BOOL103,
BOOL103_NUMTRUE,
BOOL103_TOTAL,
BOOL103_TRUEDATE,
BOOL103_TRUEVISIT,
BOOL104,
BOOL104_NUMTRUE,
BOOL104_TOTAL,
BOOL104_TRUEDATE,
BOOL104_TRUEVISIT,
BOOL105,
BOOL105_NUMTRUE,
BOOL105_TOTAL,
BOOL105_TRUEDATE,
BOOL105_TRUEVISIT,
BOOL106,
BOOL106_NUMTRUE,
BOOL106_TOTAL,
BOOL106_TRUEDATE,
BOOL106_TRUEVISIT,
BOOL107,
BOOL107_NUMTRUE,
BOOL107_TOTAL,
BOOL107_TRUEDATE,
BOOL107_TRUEVISIT,
BOOL108,
BOOL108_NUMTRUE,
BOOL108_TOTAL,
BOOL108_TRUEDATE,
BOOL108_TRUEVISIT,
BOOL109,
BOOL109_NUMTRUE,
BOOL109_TOTAL,
BOOL109_TRUEDATE,
BOOL109_TRUEVISIT,
BOOL110,
BOOL110_NUMTRUE,
BOOL110_TOTAL,
BOOL110_TRUEDATE,
BOOL110_TRUEVISIT,
BOOL111,
BOOL111_NUMTRUE,
BOOL111_TOTAL,
BOOL111_TRUEDATE,
BOOL111_TRUEVISIT,
BOOL112,
BOOL112_NUMTRUE,
BOOL112_TOTAL,
BOOL112_TRUEDATE,
BOOL112_TRUEVISIT,
BOOL113,
BOOL113_NUMTRUE,
BOOL113_TOTAL,
BOOL113_TRUEDATE,
BOOL113_TRUEVISIT,
BOOL114,
BOOL114_NUMTRUE,
BOOL114_TOTAL,
BOOL114_TRUEDATE,
BOOL114_TRUEVISIT,
BOOL115,
BOOL115_NUMTRUE,
BOOL115_TOTAL,
BOOL115_TRUEDATE,
BOOL115_TRUEVISIT,
BOOL116,
BOOL116_NUMTRUE,
BOOL116_TOTAL,
BOOL116_TRUEDATE,
BOOL116_TRUEVISIT,
BOOL117,
BOOL117_NUMTRUE,
BOOL117_TOTAL,
BOOL117_TRUEDATE,
BOOL117_TRUEVISIT,
BOOL118,
BOOL118_NUMTRUE,
BOOL118_TOTAL,
BOOL118_TRUEDATE,
BOOL118_TRUEVISIT,
BOOL119,
BOOL119_NUMTRUE,
BOOL119_TOTAL,
BOOL119_TRUEDATE,
BOOL119_TRUEVISIT,
BOOL120,
BOOL120_NUMTRUE,
BOOL120_TOTAL,
BOOL120_TRUEDATE,
BOOL120_TRUEVISIT,
BOOL121,
BOOL121_NUMTRUE,
BOOL121_TOTAL,
BOOL121_TRUEDATE,
BOOL121_TRUEVISIT,
BOOL122,
BOOL122_NUMTRUE,
BOOL122_TOTAL,
BOOL122_TRUEDATE,
BOOL122_TRUEVISIT,
BOOL123,
BOOL123_NUMTRUE,
BOOL123_TOTAL,
BOOL123_TRUEDATE,
BOOL123_TRUEVISIT,
BOOL124,
BOOL124_NUMTRUE,
BOOL124_TOTAL,
BOOL124_TRUEDATE,
BOOL124_TRUEVISIT,
BOOL125,
BOOL125_NUMTRUE,
BOOL125_TOTAL,
BOOL125_TRUEDATE,
BOOL125_TRUEVISIT,
BOOL126,
BOOL126_NUMTRUE,
BOOL126_TOTAL,
BOOL126_TRUEDATE,
BOOL126_TRUEVISIT,
BOOL127,
BOOL127_NUMTRUE,
BOOL127_TOTAL,
BOOL127_TRUEDATE,
BOOL127_TRUEVISIT,
BOOL128,
BOOL128_NUMTRUE,
BOOL128_TOTAL,
BOOL128_TRUEDATE,
BOOL128_TRUEVISIT,
BOOL129,
BOOL129_NUMTRUE,
BOOL129_TOTAL,
BOOL129_TRUEDATE,
BOOL129_TRUEVISIT,
BOOL130,
BOOL130_NUMTRUE,
BOOL130_TOTAL,
BOOL130_TRUEDATE,
BOOL130_TRUEVISIT,
BOOL131,
BOOL131_NUMTRUE,
BOOL131_TOTAL,
BOOL131_TRUEDATE,
BOOL131_TRUEVISIT,
BOOL132,
BOOL132_NUMTRUE,
BOOL132_TOTAL,
BOOL132_TRUEDATE,
BOOL132_TRUEVISIT,
BOOL133,
BOOL133_NUMTRUE,
BOOL133_TOTAL,
BOOL133_TRUEDATE,
BOOL133_TRUEVISIT,
BOOL134,
BOOL134_NUMTRUE,
BOOL134_TOTAL,
BOOL134_TRUEDATE,
BOOL134_TRUEVISIT,
BOOL135,
BOOL135_NUMTRUE,
BOOL135_TOTAL,
BOOL135_TRUEDATE,
BOOL135_TRUEVISIT,
BOOL136,
BOOL136_NUMTRUE,
BOOL136_TOTAL,
BOOL136_TRUEDATE,
BOOL136_TRUEVISIT,
BOOL137,
BOOL137_NUMTRUE,
BOOL137_TOTAL,
BOOL137_TRUEDATE,
BOOL137_TRUEVISIT,
BOOL138,
BOOL138_NUMTRUE,
BOOL138_TOTAL,
BOOL138_TRUEDATE,
BOOL138_TRUEVISIT,
BOOL139,
BOOL139_NUMTRUE,
BOOL139_TOTAL,
BOOL139_TRUEDATE,
BOOL139_TRUEVISIT,
BOOL140,
BOOL140_NUMTRUE,
BOOL140_TOTAL,
BOOL140_TRUEDATE,
BOOL140_TRUEVISIT,
BOOL141,
BOOL141_NUMTRUE,
BOOL141_TOTAL,
BOOL141_TRUEDATE,
BOOL141_TRUEVISIT,
BOOL142,
BOOL142_NUMTRUE,
BOOL142_TOTAL,
BOOL142_TRUEDATE,
BOOL142_TRUEVISIT,
BOOL143,
BOOL143_NUMTRUE,
BOOL143_TOTAL,
BOOL143_TRUEDATE,
BOOL143_TRUEVISIT,
BOOL144,
BOOL144_NUMTRUE,
BOOL144_TOTAL,
BOOL144_TRUEDATE,
BOOL144_TRUEVISIT,
BOOL145,
BOOL145_NUMTRUE,
BOOL145_TOTAL,
BOOL145_TRUEDATE,
BOOL145_TRUEVISIT,
BOOL146,
BOOL146_NUMTRUE,
BOOL146_TOTAL,
BOOL146_TRUEDATE,
BOOL146_TRUEVISIT,
BOOL147,
BOOL147_NUMTRUE,
BOOL147_TOTAL,
BOOL147_TRUEDATE,
BOOL147_TRUEVISIT,
BOOL148,
BOOL148_NUMTRUE,
BOOL148_TOTAL,
BOOL148_TRUEDATE,
BOOL148_TRUEVISIT,
BOOL149,
BOOL149_NUMTRUE,
BOOL149_TOTAL,
BOOL149_TRUEDATE,
BOOL149_TRUEVISIT,
BOOL150,
BOOL150_NUMTRUE,
BOOL150_TOTAL,
BOOL150_TRUEDATE,
BOOL150_TRUEVISIT,
BOOL151,
BOOL151_NUMTRUE,
BOOL151_TOTAL,
BOOL151_TRUEDATE,
BOOL151_TRUEVISIT,
BOOL152,
BOOL152_NUMTRUE,
BOOL152_TOTAL,
BOOL152_TRUEDATE,
BOOL152_TRUEVISIT,
BOOL153,
BOOL153_NUMTRUE,
BOOL153_TOTAL,
BOOL153_TRUEDATE,
BOOL153_TRUEVISIT,
BOOL154,
BOOL154_NUMTRUE,
BOOL154_TOTAL,
BOOL154_TRUEDATE,
BOOL154_TRUEVISIT,
BOOL155,
BOOL155_NUMTRUE,
BOOL155_TOTAL,
BOOL155_TRUEDATE,
BOOL155_TRUEVISIT,
BOOL156,
BOOL156_NUMTRUE,
BOOL156_TOTAL,
BOOL156_TRUEDATE,
BOOL156_TRUEVISIT,
BOOL157,
BOOL157_NUMTRUE,
BOOL157_TOTAL,
BOOL157_TRUEDATE,
BOOL157_TRUEVISIT,
BOOL158,
BOOL158_NUMTRUE,
BOOL158_TOTAL,
BOOL158_TRUEDATE,
BOOL158_TRUEVISIT,
BOOL159,
BOOL159_NUMTRUE,
BOOL159_TOTAL,
BOOL159_TRUEDATE,
BOOL159_TRUEVISIT,
BOOL160,
BOOL160_NUMTRUE,
BOOL160_TOTAL,
BOOL160_TRUEDATE,
BOOL160_TRUEVISIT,
BOOL161,
BOOL161_NUMTRUE,
BOOL161_TOTAL,
BOOL161_TRUEDATE,
BOOL161_TRUEVISIT,
BOOL162,
BOOL162_NUMTRUE,
BOOL162_TOTAL,
BOOL162_TRUEDATE,
BOOL162_TRUEVISIT,
BOOL163,
BOOL163_NUMTRUE,
BOOL163_TOTAL,
BOOL163_TRUEDATE,
BOOL163_TRUEVISIT,
BOOL164,
BOOL164_NUMTRUE,
BOOL164_TOTAL,
BOOL164_TRUEDATE,
BOOL164_TRUEVISIT,
BOOL165,
BOOL165_NUMTRUE,
BOOL165_TOTAL,
BOOL165_TRUEDATE,
BOOL165_TRUEVISIT,
BOOL166,
BOOL166_NUMTRUE,
BOOL166_TOTAL,
BOOL166_TRUEDATE,
BOOL166_TRUEVISIT,
BOOL167,
BOOL167_NUMTRUE,
BOOL167_TOTAL,
BOOL167_TRUEDATE,
BOOL167_TRUEVISIT,
BOOL168,
BOOL168_NUMTRUE,
BOOL168_TOTAL,
BOOL168_TRUEDATE,
BOOL168_TRUEVISIT,
PRG169,
PRG169_LASTSTART_VISIT,
PRG169_LASTSTART_DATE,
PRG170,
PRG170_LASTSTART_VISIT,
PRG170_LASTSTART_DATE,
BOOL171,
BOOL171_NUMTRUE,
BOOL171_TOTAL,
BOOL171_TRUEDATE,
BOOL171_TRUEVISIT,
BOOL172,
BOOL172_NUMTRUE,
BOOL172_TOTAL,
BOOL172_TRUEDATE,
BOOL172_TRUEVISIT,
BOOL173,
BOOL173_NUMTRUE,
BOOL173_TOTAL,
BOOL173_TRUEDATE,
BOOL173_TRUEVISIT,
BOOL174,
BOOL174_NUMTRUE,
BOOL174_TOTAL,
BOOL174_TRUEDATE,
BOOL174_TRUEVISIT,
BOOL175,
BOOL175_NUMTRUE,
BOOL175_TOTAL,
BOOL175_TRUEDATE,
BOOL175_TRUEVISIT,
BOOL176,
BOOL176_NUMTRUE,
BOOL176_TOTAL,
BOOL176_TRUEDATE,
BOOL176_TRUEVISIT,
BOOL177,
BOOL177_NUMTRUE,
BOOL177_TOTAL,
BOOL177_TRUEDATE,
BOOL177_TRUEVISIT,
BOOL178,
BOOL178_NUMTRUE,
BOOL178_TOTAL,
BOOL178_TRUEDATE,
BOOL178_TRUEVISIT,
BOOL179,
BOOL179_NUMTRUE,
BOOL179_TOTAL,
BOOL179_TRUEDATE,
BOOL179_TRUEVISIT,
BOOL180,
BOOL180_NUMTRUE,
BOOL180_TOTAL,
BOOL180_TRUEDATE,
BOOL180_TRUEVISIT,
BOOL181,
BOOL181_NUMTRUE,
BOOL181_TOTAL,
BOOL181_TRUEDATE,
BOOL181_TRUEVISIT,
BOOL182,
BOOL182_NUMTRUE,
BOOL182_TOTAL,
BOOL182_TRUEDATE,
BOOL182_TRUEVISIT,
BOOL183,
BOOL183_NUMTRUE,
BOOL183_TOTAL,
BOOL183_TRUEDATE,
BOOL183_TRUEVISIT,
BOOL184,
BOOL184_NUMTRUE,
BOOL184_TOTAL,
BOOL184_TRUEDATE,
BOOL184_TRUEVISIT,
BOOL185,
BOOL185_NUMTRUE,
BOOL185_TOTAL,
BOOL185_TRUEDATE,
BOOL185_TRUEVISIT,
BOOL186,
BOOL186_NUMTRUE,
BOOL186_TOTAL,
BOOL186_TRUEDATE,
BOOL186_TRUEVISIT,
BOOL187,
BOOL187_NUMTRUE,
BOOL187_TOTAL,
BOOL187_TRUEDATE,
BOOL187_TRUEVISIT,
BOOL188,
BOOL188_NUMTRUE,
BOOL188_TOTAL,
BOOL188_TRUEDATE,
BOOL188_TRUEVISIT,
BOOL189,
BOOL189_NUMTRUE,
BOOL189_TOTAL,
BOOL189_TRUEDATE,
BOOL189_TRUEVISIT,
BOOL190,
BOOL190_NUMTRUE,
BOOL190_TOTAL,
BOOL190_TRUEDATE,
BOOL190_TRUEVISIT,
BOOL191,
BOOL191_NUMTRUE,
BOOL191_TOTAL,
BOOL191_TRUEDATE,
BOOL191_TRUEVISIT,
BOOL192,
BOOL192_NUMTRUE,
BOOL192_TOTAL,
BOOL192_TRUEDATE,
BOOL192_TRUEVISIT,
BOOL193,
BOOL193_NUMTRUE,
BOOL193_TOTAL,
BOOL193_TRUEDATE,
BOOL193_TRUEVISIT,
BOOL194,
BOOL194_NUMTRUE,
BOOL194_TOTAL,
BOOL194_TRUEDATE,
BOOL194_TRUEVISIT,
BOOL195,
BOOL195_NUMTRUE,
BOOL195_TOTAL,
BOOL195_TRUEDATE,
BOOL195_TRUEVISIT,
VISITOR_ID
)
SELECT
P006C6132.BOOL0,
P006C6132.BOOL0_NUMTRUE,
P006C6132.BOOL0_TOTAL,
P006C6132.BOOL0_TRUEDATE,
P006C6132.BOOL0_TRUEVISIT,
P006C6132.BOOL1,
P006C6132.BOOL1_NUMTRUE,
P006C6132.BOOL1_TOTAL,
P006C6132.BOOL1_TRUEDATE,
P006C6132.BOOL1_TRUEVISIT,
P006C6132.BOOL2,
P006C6132.BOOL2_NUMTRUE,
P006C6132.BOOL2_TOTAL,
P006C6132.BOOL2_TRUEDATE,
P006C6132.BOOL2_TRUEVISIT,
P006C6132.BOOL3,
P006C6132.BOOL3_NUMTRUE,
P006C6132.BOOL3_TOTAL,
P006C6132.BOOL3_TRUEDATE,
P006C6132.BOOL3_TRUEVISIT,
P006C6132.BOOL4,
P006C6132.BOOL4_NUMTRUE,
P006C6132.BOOL4_TOTAL,
P006C6132.BOOL4_TRUEDATE,
P006C6132.BOOL4_TRUEVISIT,
P006C6132.BOOL5,
P006C6132.BOOL5_NUMTRUE,
P006C6132.BOOL5_TOTAL,
P006C6132.BOOL5_TRUEDATE,
P006C6132.BOOL5_TRUEVISIT,
P006C6132.BOOL6,
P006C6132.BOOL6_NUMTRUE,
P006C6132.BOOL6_TOTAL,
P006C6132.BOOL6_TRUEDATE,
P006C6132.BOOL6_TRUEVISIT,
P006C6132.BOOL7,
P006C6132.BOOL7_NUMTRUE,
P006C6132.BOOL7_TOTAL,
P006C6132.BOOL7_TRUEDATE,
P006C6132.BOOL7_TRUEVISIT,
P006C6132.BOOL8,
P006C6132.BOOL8_NUMTRUE,
P006C6132.BOOL8_TOTAL,
P006C6132.BOOL8_TRUEDATE,
P006C6132.BOOL8_TRUEVISIT,
P006C6132.BOOL9,
P006C6132.BOOL9_NUMTRUE,
P006C6132.BOOL9_TOTAL,
P006C6132.BOOL9_TRUEDATE,
P006C6132.BOOL9_TRUEVISIT,
P006C6132.BOOL10,
P006C6132.BOOL10_NUMTRUE,
P006C6132.BOOL10_TOTAL,
P006C6132.BOOL10_TRUEDATE,
P006C6132.BOOL10_TRUEVISIT,
P006C6132.BOOL11,
P006C6132.BOOL11_NUMTRUE,
P006C6132.BOOL11_TOTAL,
P006C6132.BOOL11_TRUEDATE,
P006C6132.BOOL11_TRUEVISIT,
P006C6132.BOOL12,
P006C6132.BOOL12_NUMTRUE,
P006C6132.BOOL12_TOTAL,
P006C6132.BOOL12_TRUEDATE,
P006C6132.BOOL12_TRUEVISIT,
P006C6132.BOOL13,
P006C6132.BOOL13_NUMTRUE,
P006C6132.BOOL13_TOTAL,
P006C6132.BOOL13_TRUEDATE,
P006C6132.BOOL13_TRUEVISIT,
P006C6132.BOOL14,
P006C6132.BOOL14_NUMTRUE,
P006C6132.BOOL14_TOTAL,
P006C6132.BOOL14_TRUEDATE,
P006C6132.BOOL14_TRUEVISIT,
P006C6132.BOOL15,
P006C6132.BOOL15_NUMTRUE,
P006C6132.BOOL15_TOTAL,
P006C6132.BOOL15_TRUEDATE,
P006C6132.BOOL15_TRUEVISIT,
P006C6132.BOOL16,
P006C6132.BOOL16_NUMTRUE,
P006C6132.BOOL16_TOTAL,
P006C6132.BOOL16_TRUEDATE,
P006C6132.BOOL16_TRUEVISIT,
P006C6132.BOOL17,
P006C6132.BOOL17_NUMTRUE,
P006C6132.BOOL17_TOTAL,
P006C6132.BOOL17_TRUEDATE,
P006C6132.BOOL17_TRUEVISIT,
P006C6132.BOOL18,
P006C6132.BOOL18_NUMTRUE,
P006C6132.BOOL18_TOTAL,
P006C6132.BOOL18_TRUEDATE,
P006C6132.BOOL18_TRUEVISIT,
P006C6132.BOOL19,
P006C6132.BOOL19_NUMTRUE,
P006C6132.BOOL19_TOTAL,
P006C6132.BOOL19_TRUEDATE,
P006C6132.BOOL19_TRUEVISIT,
P006C6132.BOOL20,
P006C6132.BOOL20_NUMTRUE,
P006C6132.BOOL20_TOTAL,
P006C6132.BOOL20_TRUEDATE,
P006C6132.BOOL20_TRUEVISIT,
P006C6132.BOOL21,
P006C6132.BOOL21_NUMTRUE,
P006C6132.BOOL21_TOTAL,
P006C6132.BOOL21_TRUEDATE,
P006C6132.BOOL21_TRUEVISIT,
P006C6132.BOOL22,
P006C6132.BOOL22_NUMTRUE,
P006C6132.BOOL22_TOTAL,
P006C6132.BOOL22_TRUEDATE,
P006C6132.BOOL22_TRUEVISIT,
P006C6132.BOOL23,
P006C6132.BOOL23_NUMTRUE,
P006C6132.BOOL23_TOTAL,
P006C6132.BOOL23_TRUEDATE,
P006C6132.BOOL23_TRUEVISIT,
P006C6132.BOOL24,
P006C6132.BOOL24_NUMTRUE,
P006C6132.BOOL24_TOTAL,
P006C6132.BOOL24_TRUEDATE,
P006C6132.BOOL24_TRUEVISIT,
P006C6132.BOOL25,
P006C6132.BOOL25_NUMTRUE,
P006C6132.BOOL25_TOTAL,
P006C6132.BOOL25_TRUEDATE,
P006C6132.BOOL25_TRUEVISIT,
P006C6132.BOOL26,
P006C6132.BOOL26_NUMTRUE,
P006C6132.BOOL26_TOTAL,
P006C6132.BOOL26_TRUEDATE,
P006C6132.BOOL26_TRUEVISIT,
P006C6132.BOOL27,
P006C6132.BOOL27_NUMTRUE,
P006C6132.BOOL27_TOTAL,
P006C6132.BOOL27_TRUEDATE,
P006C6132.BOOL27_TRUEVISIT,
P006C6132.BOOL28,
P006C6132.BOOL28_NUMTRUE,
P006C6132.BOOL28_TOTAL,
P006C6132.BOOL28_TRUEDATE,
P006C6132.BOOL28_TRUEVISIT,
P006C6132.BOOL29,
P006C6132.BOOL29_NUMTRUE,
P006C6132.BOOL29_TOTAL,
P006C6132.BOOL29_TRUEDATE,
P006C6132.BOOL29_TRUEVISIT,
P006C6132.BOOL30,
P006C6132.BOOL30_NUMTRUE,
P006C6132.BOOL30_TOTAL,
P006C6132.BOOL30_TRUEDATE,
P006C6132.BOOL30_TRUEVISIT,
P006C6132.BOOL31,
P006C6132.BOOL31_NUMTRUE,
P006C6132.BOOL31_TOTAL,
P006C6132.BOOL31_TRUEDATE,
P006C6132.BOOL31_TRUEVISIT,
P006C6132.BOOL32,
P006C6132.BOOL32_NUMTRUE,
P006C6132.BOOL32_TOTAL,
P006C6132.BOOL32_TRUEDATE,
P006C6132.BOOL32_TRUEVISIT,
P006C6132.BOOL33,
P006C6132.BOOL33_NUMTRUE,
P006C6132.BOOL33_TOTAL,
P006C6132.BOOL33_TRUEDATE,
P006C6132.BOOL33_TRUEVISIT,
P006C6132.BOOL34,
P006C6132.BOOL34_NUMTRUE,
P006C6132.BOOL34_TOTAL,
P006C6132.BOOL34_TRUEDATE,
P006C6132.BOOL34_TRUEVISIT,
P006C6132.BOOL35,
P006C6132.BOOL35_NUMTRUE,
P006C6132.BOOL35_TOTAL,
P006C6132.BOOL35_TRUEDATE,
P006C6132.BOOL35_TRUEVISIT,
P006C6132.BOOL36,
P006C6132.BOOL36_NUMTRUE,
P006C6132.BOOL36_TOTAL,
P006C6132.BOOL36_TRUEDATE,
P006C6132.BOOL36_TRUEVISIT,
P006C6132.BOOL37,
P006C6132.BOOL37_NUMTRUE,
P006C6132.BOOL37_TOTAL,
P006C6132.BOOL37_TRUEDATE,
P006C6132.BOOL37_TRUEVISIT,
P006C6132.BOOL38,
P006C6132.BOOL38_NUMTRUE,
P006C6132.BOOL38_TOTAL,
P006C6132.BOOL38_TRUEDATE,
P006C6132.BOOL38_TRUEVISIT,
P006C6132.BOOL39,
P006C6132.BOOL39_NUMTRUE,
P006C6132.BOOL39_TOTAL,
P006C6132.BOOL39_TRUEDATE,
P006C6132.BOOL39_TRUEVISIT,
P006C6132.BOOL40,
P006C6132.BOOL40_NUMTRUE,
P006C6132.BOOL40_TOTAL,
P006C6132.BOOL40_TRUEDATE,
P006C6132.BOOL40_TRUEVISIT,
P011ABBBF.BOOL0,
P011ABBBF.BOOL0_NUMTRUE,
P011ABBBF.BOOL0_TOTAL,
P011ABBBF.BOOL0_TRUEDATE,
P011ABBBF.BOOL0_TRUEVISIT,
P011ABBBF.BOOL1,
P011ABBBF.BOOL1_NUMTRUE,
P011ABBBF.BOOL1_TOTAL,
P011ABBBF.BOOL1_TRUEDATE,
P011ABBBF.BOOL1_TRUEVISIT,
P011ABBBF.BOOL2,
P011ABBBF.BOOL2_NUMTRUE,
P011ABBBF.BOOL2_TOTAL,
P011ABBBF.BOOL2_TRUEDATE,
P011ABBBF.BOOL2_TRUEVISIT,
P011ABBBF.BOOL3,
P011ABBBF.BOOL3_NUMTRUE,
P011ABBBF.BOOL3_TOTAL,
P011ABBBF.BOOL3_TRUEDATE,
P011ABBBF.BOOL3_TRUEVISIT,
P011ABBBF.BOOL4,
P011ABBBF.BOOL4_NUMTRUE,
P011ABBBF.BOOL4_TOTAL,
P011ABBBF.BOOL4_TRUEDATE,
P011ABBBF.BOOL4_TRUEVISIT,
P011ABBBF.BOOL5,
P011ABBBF.BOOL5_NUMTRUE,
P011ABBBF.BOOL5_TOTAL,
P011ABBBF.BOOL5_TRUEDATE,
P011ABBBF.BOOL5_TRUEVISIT,
P011ABBBF.BOOL6,
P011ABBBF.BOOL6_NUMTRUE,
P011ABBBF.BOOL6_TOTAL,
P011ABBBF.BOOL6_TRUEDATE,
P011ABBBF.BOOL6_TRUEVISIT,
P011ABBBF.BOOL7,
P011ABBBF.BOOL7_NUMTRUE,
P011ABBBF.BOOL7_TOTAL,
P011ABBBF.BOOL7_TRUEDATE,
P011ABBBF.BOOL7_TRUEVISIT,
P011ABBBF.BOOL8,
P011ABBBF.BOOL8_NUMTRUE,
P011ABBBF.BOOL8_TOTAL,
P011ABBBF.BOOL8_TRUEDATE,
P011ABBBF.BOOL8_TRUEVISIT,
P011ABBBF.BOOL9,
P011ABBBF.BOOL9_NUMTRUE,
P011ABBBF.BOOL9_TOTAL,
P011ABBBF.BOOL9_TRUEDATE,
P011ABBBF.BOOL9_TRUEVISIT,
P011ABBBF.BOOL10,
P011ABBBF.BOOL10_NUMTRUE,
P011ABBBF.BOOL10_TOTAL,
P011ABBBF.BOOL10_TRUEDATE,
P011ABBBF.BOOL10_TRUEVISIT,
P011ABBBF.BOOL11,
P011ABBBF.BOOL11_NUMTRUE,
P011ABBBF.BOOL11_TOTAL,
P011ABBBF.BOOL11_TRUEDATE,
P011ABBBF.BOOL11_TRUEVISIT,
P011ABBBF.BOOL12,
P011ABBBF.BOOL12_NUMTRUE,
P011ABBBF.BOOL12_TOTAL,
P011ABBBF.BOOL12_TRUEDATE,
P011ABBBF.BOOL12_TRUEVISIT,
P011ABBBF.BOOL13,
P011ABBBF.BOOL13_NUMTRUE,
P011ABBBF.BOOL13_TOTAL,
P011ABBBF.BOOL13_TRUEDATE,
P011ABBBF.BOOL13_TRUEVISIT,
P011ABBBF.BOOL14,
P011ABBBF.BOOL14_NUMTRUE,
P011ABBBF.BOOL14_TOTAL,
P011ABBBF.BOOL14_TRUEDATE,
P011ABBBF.BOOL14_TRUEVISIT,
P011ABBBF.BOOL15,
P011ABBBF.BOOL15_NUMTRUE,
P011ABBBF.BOOL15_TOTAL,
P011ABBBF.BOOL15_TRUEDATE,
P011ABBBF.BOOL15_TRUEVISIT,
P011ABBBF.BOOL16,
P011ABBBF.BOOL16_NUMTRUE,
P011ABBBF.BOOL16_TOTAL,
P011ABBBF.BOOL16_TRUEDATE,
P011ABBBF.BOOL16_TRUEVISIT,
P011ABBBF.BOOL17,
P011ABBBF.BOOL17_NUMTRUE,
P011ABBBF.BOOL17_TOTAL,
P011ABBBF.BOOL17_TRUEDATE,
P011ABBBF.BOOL17_TRUEVISIT,
P011ABBBF.BOOL18,
P011ABBBF.BOOL18_NUMTRUE,
P011ABBBF.BOOL18_TOTAL,
P011ABBBF.BOOL18_TRUEDATE,
P011ABBBF.BOOL18_TRUEVISIT,
P011ABBBF.BOOL19,
P011ABBBF.BOOL19_NUMTRUE,
P011ABBBF.BOOL19_TOTAL,
P011ABBBF.BOOL19_TRUEDATE,
P011ABBBF.BOOL19_TRUEVISIT,
P011ABBBF.BOOL20,
P011ABBBF.BOOL20_NUMTRUE,
P011ABBBF.BOOL20_TOTAL,
P011ABBBF.BOOL20_TRUEDATE,
P011ABBBF.BOOL20_TRUEVISIT,
P011ABBBF.BOOL21,
P011ABBBF.BOOL21_NUMTRUE,
P011ABBBF.BOOL21_TOTAL,
P011ABBBF.BOOL21_TRUEDATE,
P011ABBBF.BOOL21_TRUEVISIT,
P011ABBBF.BOOL22,
P011ABBBF.BOOL22_NUMTRUE,
P011ABBBF.BOOL22_TOTAL,
P011ABBBF.BOOL22_TRUEDATE,
P011ABBBF.BOOL22_TRUEVISIT,
P011ABBBF.BOOL23,
P011ABBBF.BOOL23_NUMTRUE,
P011ABBBF.BOOL23_TOTAL,
P011ABBBF.BOOL23_TRUEDATE,
P011ABBBF.BOOL23_TRUEVISIT,
P011ABBBF.BOOL24,
P011ABBBF.BOOL24_NUMTRUE,
P011ABBBF.BOOL24_TOTAL,
P011ABBBF.BOOL24_TRUEDATE,
P011ABBBF.BOOL24_TRUEVISIT,
P011ABBBF.BOOL25,
P011ABBBF.BOOL25_NUMTRUE,
P011ABBBF.BOOL25_TOTAL,
P011ABBBF.BOOL25_TRUEDATE,
P011ABBBF.BOOL25_TRUEVISIT,
P011ABBBF.BOOL26,
P011ABBBF.BOOL26_NUMTRUE,
P011ABBBF.BOOL26_TOTAL,
P011ABBBF.BOOL26_TRUEDATE,
P011ABBBF.BOOL26_TRUEVISIT,
P011ABBBF.BOOL27,
P011ABBBF.BOOL27_NUMTRUE,
P011ABBBF.BOOL27_TOTAL,
P011ABBBF.BOOL27_TRUEDATE,
P011ABBBF.BOOL27_TRUEVISIT,
P011ABBBF.BOOL28,
P011ABBBF.BOOL28_NUMTRUE,
P011ABBBF.BOOL28_TOTAL,
P011ABBBF.BOOL28_TRUEDATE,
P011ABBBF.BOOL28_TRUEVISIT,
P011ABBBF.BOOL29,
P011ABBBF.BOOL29_NUMTRUE,
P011ABBBF.BOOL29_TOTAL,
P011ABBBF.BOOL29_TRUEDATE,
P011ABBBF.BOOL29_TRUEVISIT,
P011ABBBF.BOOL30,
P011ABBBF.BOOL30_NUMTRUE,
P011ABBBF.BOOL30_TOTAL,
P011ABBBF.BOOL30_TRUEDATE,
P011ABBBF.BOOL30_TRUEVISIT,
P011ABBBF.BOOL31,
P011ABBBF.BOOL31_NUMTRUE,
P011ABBBF.BOOL31_TOTAL,
P011ABBBF.BOOL31_TRUEDATE,
P011ABBBF.BOOL31_TRUEVISIT,
P0236B8D8.BOOL0,
P0236B8D8.BOOL0_NUMTRUE,
P0236B8D8.BOOL0_TOTAL,
P0236B8D8.BOOL0_TRUEDATE,
P0236B8D8.BOOL0_TRUEVISIT,
P0236B8D8.BOOL1,
P0236B8D8.BOOL1_NUMTRUE,
P0236B8D8.BOOL1_TOTAL,
P0236B8D8.BOOL1_TRUEDATE,
P0236B8D8.BOOL1_TRUEVISIT,
P0236B8D8.BOOL2,
P0236B8D8.BOOL2_NUMTRUE,
P0236B8D8.BOOL2_TOTAL,
P0236B8D8.BOOL2_TRUEDATE,
P0236B8D8.BOOL2_TRUEVISIT,
P0236B8D8.BOOL3,
P0236B8D8.BOOL3_NUMTRUE,
P0236B8D8.BOOL3_TOTAL,
P0236B8D8.BOOL3_TRUEDATE,
P0236B8D8.BOOL3_TRUEVISIT,
P0236B8D8.BOOL4,
P0236B8D8.BOOL4_NUMTRUE,
P0236B8D8.BOOL4_TOTAL,
P0236B8D8.BOOL4_TRUEDATE,
P0236B8D8.BOOL4_TRUEVISIT,
P0236B8D8.BOOL5,
P0236B8D8.BOOL5_NUMTRUE,
P0236B8D8.BOOL5_TOTAL,
P0236B8D8.BOOL5_TRUEDATE,
P0236B8D8.BOOL5_TRUEVISIT,
P0236B8D8.BOOL6,
P0236B8D8.BOOL6_NUMTRUE,
P0236B8D8.BOOL6_TOTAL,
P0236B8D8.BOOL6_TRUEDATE,
P0236B8D8.BOOL6_TRUEVISIT,
P0236B8D8.BOOL7,
P0236B8D8.BOOL7_NUMTRUE,
P0236B8D8.BOOL7_TOTAL,
P0236B8D8.BOOL7_TRUEDATE,
P0236B8D8.BOOL7_TRUEVISIT,
P0236B8D8.BOOL8,
P0236B8D8.BOOL8_NUMTRUE,
P0236B8D8.BOOL8_TOTAL,
P0236B8D8.BOOL8_TRUEDATE,
P0236B8D8.BOOL8_TRUEVISIT,
P0236B8D8.BOOL9,
P0236B8D8.BOOL9_NUMTRUE,
P0236B8D8.BOOL9_TOTAL,
P0236B8D8.BOOL9_TRUEDATE,
P0236B8D8.BOOL9_TRUEVISIT,
P0236B8D8.BOOL10,
P0236B8D8.BOOL10_NUMTRUE,
P0236B8D8.BOOL10_TOTAL,
P0236B8D8.BOOL10_TRUEDATE,
P0236B8D8.BOOL10_TRUEVISIT,
P0236B8D8.BOOL11,
P0236B8D8.BOOL11_NUMTRUE,
P0236B8D8.BOOL11_TOTAL,
P0236B8D8.BOOL11_TRUEDATE,
P0236B8D8.BOOL11_TRUEVISIT,
P0236B8D8.BOOL12,
P0236B8D8.BOOL12_NUMTRUE,
P0236B8D8.BOOL12_TOTAL,
P0236B8D8.BOOL12_TRUEDATE,
P0236B8D8.BOOL12_TRUEVISIT,
P0236B8D8.BOOL13,
P0236B8D8.BOOL13_NUMTRUE,
P0236B8D8.BOOL13_TOTAL,
P0236B8D8.BOOL13_TRUEDATE,
P0236B8D8.BOOL13_TRUEVISIT,
P0236B8D8.BOOL14,
P0236B8D8.BOOL14_NUMTRUE,
P0236B8D8.BOOL14_TOTAL,
P0236B8D8.BOOL14_TRUEDATE,
P0236B8D8.BOOL14_TRUEVISIT,
P0236B8D8.BOOL15,
P0236B8D8.BOOL15_NUMTRUE,
P0236B8D8.BOOL15_TOTAL,
P0236B8D8.BOOL15_TRUEDATE,
P0236B8D8.BOOL15_TRUEVISIT,
P0236B8D8.BOOL16,
P0236B8D8.BOOL16_NUMTRUE,
P0236B8D8.BOOL16_TOTAL,
P0236B8D8.BOOL16_TRUEDATE,
P0236B8D8.BOOL16_TRUEVISIT,
P0236B8D8.BOOL17,
P0236B8D8.BOOL17_NUMTRUE,
P0236B8D8.BOOL17_TOTAL,
P0236B8D8.BOOL17_TRUEDATE,
P0236B8D8.BOOL17_TRUEVISIT,
P0236B8D8.BOOL18,
P0236B8D8.BOOL18_NUMTRUE,
P0236B8D8.BOOL18_TOTAL,
P0236B8D8.BOOL18_TRUEDATE,
P0236B8D8.BOOL18_TRUEVISIT,
P03BD6763.BOOL0,
P03BD6763.BOOL0_NUMTRUE,
P03BD6763.BOOL0_TOTAL,
P03BD6763.BOOL0_TRUEDATE,
P03BD6763.BOOL0_TRUEVISIT,
P03BD6763.BOOL1,
P03BD6763.BOOL1_NUMTRUE,
P03BD6763.BOOL1_TOTAL,
P03BD6763.BOOL1_TRUEDATE,
P03BD6763.BOOL1_TRUEVISIT,
P03BD6763.BOOL2,
P03BD6763.BOOL2_NUMTRUE,
P03BD6763.BOOL2_TOTAL,
P03BD6763.BOOL2_TRUEDATE,
P03BD6763.BOOL2_TRUEVISIT,
P03BD6763.BOOL3,
P03BD6763.BOOL3_NUMTRUE,
P03BD6763.BOOL3_TOTAL,
P03BD6763.BOOL3_TRUEDATE,
P03BD6763.BOOL3_TRUEVISIT,
P03BD6763.BOOL4,
P03BD6763.BOOL4_NUMTRUE,
P03BD6763.BOOL4_TOTAL,
P03BD6763.BOOL4_TRUEDATE,
P03BD6763.BOOL4_TRUEVISIT,
P03BD6763.BOOL5,
P03BD6763.BOOL5_NUMTRUE,
P03BD6763.BOOL5_TOTAL,
P03BD6763.BOOL5_TRUEDATE,
P03BD6763.BOOL5_TRUEVISIT,
P03BD6763.BOOL6,
P03BD6763.BOOL6_NUMTRUE,
P03BD6763.BOOL6_TOTAL,
P03BD6763.BOOL6_TRUEDATE,
P03BD6763.BOOL6_TRUEVISIT,
P03BD6763.BOOL7,
P03BD6763.BOOL7_NUMTRUE,
P03BD6763.BOOL7_TOTAL,
P03BD6763.BOOL7_TRUEDATE,
P03BD6763.BOOL7_TRUEVISIT,
P03BD6763.BOOL8,
P03BD6763.BOOL8_NUMTRUE,
P03BD6763.BOOL8_TOTAL,
P03BD6763.BOOL8_TRUEDATE,
P03BD6763.BOOL8_TRUEVISIT,
P03BD6763.BOOL9,
P03BD6763.BOOL9_NUMTRUE,
P03BD6763.BOOL9_TOTAL,
P03BD6763.BOOL9_TRUEDATE,
P03BD6763.BOOL9_TRUEVISIT,
P03BD6763.BOOL10,
P03BD6763.BOOL10_NUMTRUE,
P03BD6763.BOOL10_TOTAL,
P03BD6763.BOOL10_TRUEDATE,
P03BD6763.BOOL10_TRUEVISIT,
P03BD6763.BOOL11,
P03BD6763.BOOL11_NUMTRUE,
P03BD6763.BOOL11_TOTAL,
P03BD6763.BOOL11_TRUEDATE,
P03BD6763.BOOL11_TRUEVISIT,
P03BD6763.BOOL12,
P03BD6763.BOOL12_NUMTRUE,
P03BD6763.BOOL12_TOTAL,
P03BD6763.BOOL12_TRUEDATE,
P03BD6763.BOOL12_TRUEVISIT,
P03BD6763.BOOL13,
P03BD6763.BOOL13_NUMTRUE,
P03BD6763.BOOL13_TOTAL,
P03BD6763.BOOL13_TRUEDATE,
P03BD6763.BOOL13_TRUEVISIT,
P03BD6763.BOOL14,
P03BD6763.BOOL14_NUMTRUE,
P03BD6763.BOOL14_TOTAL,
P03BD6763.BOOL14_TRUEDATE,
P03BD6763.BOOL14_TRUEVISIT,
P03BD6763.BOOL15,
P03BD6763.BOOL15_NUMTRUE,
P03BD6763.BOOL15_TOTAL,
P03BD6763.BOOL15_TRUEDATE,
P03BD6763.BOOL15_TRUEVISIT,
P03BD6763.BOOL16,
P03BD6763.BOOL16_NUMTRUE,
P03BD6763.BOOL16_TOTAL,
P03BD6763.BOOL16_TRUEDATE,
P03BD6763.BOOL16_TRUEVISIT,
P03BD6763.BOOL17,
P03BD6763.BOOL17_NUMTRUE,
P03BD6763.BOOL17_TOTAL,
P03BD6763.BOOL17_TRUEDATE,
P03BD6763.BOOL17_TRUEVISIT,
P03BD6763.BOOL18,
P03BD6763.BOOL18_NUMTRUE,
P03BD6763.BOOL18_TOTAL,
P03BD6763.BOOL18_TRUEDATE,
P03BD6763.BOOL18_TRUEVISIT,
P05507FBC.BOOL0,
P05507FBC.BOOL0_NUMTRUE,
P05507FBC.BOOL0_TOTAL,
P05507FBC.BOOL0_TRUEDATE,
P05507FBC.BOOL0_TRUEVISIT,
P05507FBC.BOOL1,
P05507FBC.BOOL1_NUMTRUE,
P05507FBC.BOOL1_TOTAL,
P05507FBC.BOOL1_TRUEDATE,
P05507FBC.BOOL1_TRUEVISIT,
P05507FBC.BOOL2,
P05507FBC.BOOL2_NUMTRUE,
P05507FBC.BOOL2_TOTAL,
P05507FBC.BOOL2_TRUEDATE,
P05507FBC.BOOL2_TRUEVISIT,
P05507FBC.BOOL3,
P05507FBC.BOOL3_NUMTRUE,
P05507FBC.BOOL3_TOTAL,
P05507FBC.BOOL3_TRUEDATE,
P05507FBC.BOOL3_TRUEVISIT,
P05507FBC.BOOL4,
P05507FBC.BOOL4_NUMTRUE,
P05507FBC.BOOL4_TOTAL,
P05507FBC.BOOL4_TRUEDATE,
P05507FBC.BOOL4_TRUEVISIT,
P05507FBC.BOOL5,
P05507FBC.BOOL5_NUMTRUE,
P05507FBC.BOOL5_TOTAL,
P05507FBC.BOOL5_TRUEDATE,
P05507FBC.BOOL5_TRUEVISIT,
P05507FBC.BOOL6,
P05507FBC.BOOL6_NUMTRUE,
P05507FBC.BOOL6_TOTAL,
P05507FBC.BOOL6_TRUEDATE,
P05507FBC.BOOL6_TRUEVISIT,
P05507FBC.BOOL7,
P05507FBC.BOOL7_NUMTRUE,
P05507FBC.BOOL7_TOTAL,
P05507FBC.BOOL7_TRUEDATE,
P05507FBC.BOOL7_TRUEVISIT,
P05507FBC.BOOL8,
P05507FBC.BOOL8_NUMTRUE,
P05507FBC.BOOL8_TOTAL,
P05507FBC.BOOL8_TRUEDATE,
P05507FBC.BOOL8_TRUEVISIT,
P05507FBC.BOOL9,
P05507FBC.BOOL9_NUMTRUE,
P05507FBC.BOOL9_TOTAL,
P05507FBC.BOOL9_TRUEDATE,
P05507FBC.BOOL9_TRUEVISIT,
P05507FBC.BOOL10,
P05507FBC.BOOL10_NUMTRUE,
P05507FBC.BOOL10_TOTAL,
P05507FBC.BOOL10_TRUEDATE,
P05507FBC.BOOL10_TRUEVISIT,
P05507FBC.BOOL11,
P05507FBC.BOOL11_NUMTRUE,
P05507FBC.BOOL11_TOTAL,
P05507FBC.BOOL11_TRUEDATE,
P05507FBC.BOOL11_TRUEVISIT,
P05507FBC.BOOL12,
P05507FBC.BOOL12_NUMTRUE,
P05507FBC.BOOL12_TOTAL,
P05507FBC.BOOL12_TRUEDATE,
P05507FBC.BOOL12_TRUEVISIT,
P05507FBC.BOOL13,
P05507FBC.BOOL13_NUMTRUE,
P05507FBC.BOOL13_TOTAL,
P05507FBC.BOOL13_TRUEDATE,
P05507FBC.BOOL13_TRUEVISIT,
P05507FBC.BOOL14,
P05507FBC.BOOL14_NUMTRUE,
P05507FBC.BOOL14_TOTAL,
P05507FBC.BOOL14_TRUEDATE,
P05507FBC.BOOL14_TRUEVISIT,
P05507FBC.BOOL15,
P05507FBC.BOOL15_NUMTRUE,
P05507FBC.BOOL15_TOTAL,
P05507FBC.BOOL15_TRUEDATE,
P05507FBC.BOOL15_TRUEVISIT,
P05507FBC.BOOL16,
P05507FBC.BOOL16_NUMTRUE,
P05507FBC.BOOL16_TOTAL,
P05507FBC.BOOL16_TRUEDATE,
P05507FBC.BOOL16_TRUEVISIT,
P05507FBC.BOOL17,
P05507FBC.BOOL17_NUMTRUE,
P05507FBC.BOOL17_TOTAL,
P05507FBC.BOOL17_TRUEDATE,
P05507FBC.BOOL17_TRUEVISIT,
P05507FBC.BOOL18,
P05507FBC.BOOL18_NUMTRUE,
P05507FBC.BOOL18_TOTAL,
P05507FBC.BOOL18_TRUEDATE,
P05507FBC.BOOL18_TRUEVISIT,
P05507FBC.BOOL19,
P05507FBC.BOOL19_NUMTRUE,
P05507FBC.BOOL19_TOTAL,
P05507FBC.BOOL19_TRUEDATE,
P05507FBC.BOOL19_TRUEVISIT,
P05507FBC.BOOL20,
P05507FBC.BOOL20_NUMTRUE,
P05507FBC.BOOL20_TOTAL,
P05507FBC.BOOL20_TRUEDATE,
P05507FBC.BOOL20_TRUEVISIT,
P05507FBC.BOOL21,
P05507FBC.BOOL21_NUMTRUE,
P05507FBC.BOOL21_TOTAL,
P05507FBC.BOOL21_TRUEDATE,
P05507FBC.BOOL21_TRUEVISIT,
P05507FBC.BOOL22,
P05507FBC.BOOL22_NUMTRUE,
P05507FBC.BOOL22_TOTAL,
P05507FBC.BOOL22_TRUEDATE,
P05507FBC.BOOL22_TRUEVISIT,
P05507FBC.BOOL23,
P05507FBC.BOOL23_NUMTRUE,
P05507FBC.BOOL23_TOTAL,
P05507FBC.BOOL23_TRUEDATE,
P05507FBC.BOOL23_TRUEVISIT,
P05507FBC.BOOL24,
P05507FBC.BOOL24_NUMTRUE,
P05507FBC.BOOL24_TOTAL,
P05507FBC.BOOL24_TRUEDATE,
P05507FBC.BOOL24_TRUEVISIT,
P05507FBC.BOOL25,
P05507FBC.BOOL25_NUMTRUE,
P05507FBC.BOOL25_TOTAL,
P05507FBC.BOOL25_TRUEDATE,
P05507FBC.BOOL25_TRUEVISIT,
P05507FBC.BOOL26,
P05507FBC.BOOL26_NUMTRUE,
P05507FBC.BOOL26_TOTAL,
P05507FBC.BOOL26_TRUEDATE,
P05507FBC.BOOL26_TRUEVISIT,
P05507FBC.BOOL27,
P05507FBC.BOOL27_NUMTRUE,
P05507FBC.BOOL27_TOTAL,
P05507FBC.BOOL27_TRUEDATE,
P05507FBC.BOOL27_TRUEVISIT,
P05507FBC.BOOL28,
P05507FBC.BOOL28_NUMTRUE,
P05507FBC.BOOL28_TOTAL,
P05507FBC.BOOL28_TRUEDATE,
P05507FBC.BOOL28_TRUEVISIT,
P05507FBC.BOOL29,
P05507FBC.BOOL29_NUMTRUE,
P05507FBC.BOOL29_TOTAL,
P05507FBC.BOOL29_TRUEDATE,
P05507FBC.BOOL29_TRUEVISIT,
P0993ED7E.BOOL0,
P0993ED7E.BOOL0_NUMTRUE,
P0993ED7E.BOOL0_TOTAL,
P0993ED7E.BOOL0_TRUEDATE,
P0993ED7E.BOOL0_TRUEVISIT,
P0993ED7E.BOOL1,
P0993ED7E.BOOL1_NUMTRUE,
P0993ED7E.BOOL1_TOTAL,
P0993ED7E.BOOL1_TRUEDATE,
P0993ED7E.BOOL1_TRUEVISIT,
P0993ED7E.BOOL2,
P0993ED7E.BOOL2_NUMTRUE,
P0993ED7E.BOOL2_TOTAL,
P0993ED7E.BOOL2_TRUEDATE,
P0993ED7E.BOOL2_TRUEVISIT,
P0993ED7E.BOOL3,
P0993ED7E.BOOL3_NUMTRUE,
P0993ED7E.BOOL3_TOTAL,
P0993ED7E.BOOL3_TRUEDATE,
P0993ED7E.BOOL3_TRUEVISIT,
P0993ED7E.BOOL4,
P0993ED7E.BOOL4_NUMTRUE,
P0993ED7E.BOOL4_TOTAL,
P0993ED7E.BOOL4_TRUEDATE,
P0993ED7E.BOOL4_TRUEVISIT,
P0993ED7E.BOOL5,
P0993ED7E.BOOL5_NUMTRUE,
P0993ED7E.BOOL5_TOTAL,
P0993ED7E.BOOL5_TRUEDATE,
P0993ED7E.BOOL5_TRUEVISIT,
P0993ED7E.BOOL6,
P0993ED7E.BOOL6_NUMTRUE,
P0993ED7E.BOOL6_TOTAL,
P0993ED7E.BOOL6_TRUEDATE,
P0993ED7E.BOOL6_TRUEVISIT,
P0993ED7E.BOOL7,
P0993ED7E.BOOL7_NUMTRUE,
P0993ED7E.BOOL7_TOTAL,
P0993ED7E.BOOL7_TRUEDATE,
P0993ED7E.BOOL7_TRUEVISIT,
P0993ED7E.BOOL8,
P0993ED7E.BOOL8_NUMTRUE,
P0993ED7E.BOOL8_TOTAL,
P0993ED7E.BOOL8_TRUEDATE,
P0993ED7E.BOOL8_TRUEVISIT,
P0993ED7E.BOOL9,
P0993ED7E.BOOL9_NUMTRUE,
P0993ED7E.BOOL9_TOTAL,
P0993ED7E.BOOL9_TRUEDATE,
P0993ED7E.BOOL9_TRUEVISIT,
P0993ED7E.BOOL10,
P0993ED7E.BOOL10_NUMTRUE,
P0993ED7E.BOOL10_TOTAL,
P0993ED7E.BOOL10_TRUEDATE,
P0993ED7E.BOOL10_TRUEVISIT,
P0993ED7E.BOOL11,
P0993ED7E.BOOL11_NUMTRUE,
P0993ED7E.BOOL11_TOTAL,
P0993ED7E.BOOL11_TRUEDATE,
P0993ED7E.BOOL11_TRUEVISIT,
P0993ED7E.BOOL12,
P0993ED7E.BOOL12_NUMTRUE,
P0993ED7E.BOOL12_TOTAL,
P0993ED7E.BOOL12_TRUEDATE,
P0993ED7E.BOOL12_TRUEVISIT,
P0993ED7E.BOOL13,
P0993ED7E.BOOL13_NUMTRUE,
P0993ED7E.BOOL13_TOTAL,
P0993ED7E.BOOL13_TRUEDATE,
P0993ED7E.BOOL13_TRUEVISIT,
P0993ED7E.BOOL14,
P0993ED7E.BOOL14_NUMTRUE,
P0993ED7E.BOOL14_TOTAL,
P0993ED7E.BOOL14_TRUEDATE,
P0993ED7E.BOOL14_TRUEVISIT,
P0993ED7E.BOOL15,
P0993ED7E.BOOL15_NUMTRUE,
P0993ED7E.BOOL15_TOTAL,
P0993ED7E.BOOL15_TRUEDATE,
P0993ED7E.BOOL15_TRUEVISIT,
P0993ED7E.BOOL16,
P0993ED7E.BOOL16_NUMTRUE,
P0993ED7E.BOOL16_TOTAL,
P0993ED7E.BOOL16_TRUEDATE,
P0993ED7E.BOOL16_TRUEVISIT,
P0993ED7E.BOOL17,
P0993ED7E.BOOL17_NUMTRUE,
P0993ED7E.BOOL17_TOTAL,
P0993ED7E.BOOL17_TRUEDATE,
P0993ED7E.BOOL17_TRUEVISIT,
P0993ED7E.BOOL18,
P0993ED7E.BOOL18_NUMTRUE,
P0993ED7E.BOOL18_TOTAL,
P0993ED7E.BOOL18_TRUEDATE,
P0993ED7E.BOOL18_TRUEVISIT,
P0993ED7E.BOOL19,
P0993ED7E.BOOL19_NUMTRUE,
P0993ED7E.BOOL19_TOTAL,
P0993ED7E.BOOL19_TRUEDATE,
P0993ED7E.BOOL19_TRUEVISIT,
P0993ED7E.BOOL20,
P0993ED7E.BOOL20_NUMTRUE,
P0993ED7E.BOOL20_TOTAL,
P0993ED7E.BOOL20_TRUEDATE,
P0993ED7E.BOOL20_TRUEVISIT,
P0993ED7E.BOOL21,
P0993ED7E.BOOL21_NUMTRUE,
P0993ED7E.BOOL21_TOTAL,
P0993ED7E.BOOL21_TRUEDATE,
P0993ED7E.BOOL21_TRUEVISIT,
P0993ED7E.BOOL22,
P0993ED7E.BOOL22_NUMTRUE,
P0993ED7E.BOOL22_TOTAL,
P0993ED7E.BOOL22_TRUEDATE,
P0993ED7E.BOOL22_TRUEVISIT,
P0993ED7E.BOOL23,
P0993ED7E.BOOL23_NUMTRUE,
P0993ED7E.BOOL23_TOTAL,
P0993ED7E.BOOL23_TRUEDATE,
P0993ED7E.BOOL23_TRUEVISIT,
P0993ED7E.BOOL24,
P0993ED7E.BOOL24_NUMTRUE,
P0993ED7E.BOOL24_TOTAL,
P0993ED7E.BOOL24_TRUEDATE,
P0993ED7E.BOOL24_TRUEVISIT,
P0993ED7E.BOOL25,
P0993ED7E.BOOL25_NUMTRUE,
P0993ED7E.BOOL25_TOTAL,
P0993ED7E.BOOL25_TRUEDATE,
P0993ED7E.BOOL25_TRUEVISIT,
P0993ED7E.BOOL26,
P0993ED7E.BOOL26_NUMTRUE,
P0993ED7E.BOOL26_TOTAL,
P0993ED7E.BOOL26_TRUEDATE,
P0993ED7E.BOOL26_TRUEVISIT,
P0993ED7E.BOOL27,
P0993ED7E.BOOL27_NUMTRUE,
P0993ED7E.BOOL27_TOTAL,
P0993ED7E.BOOL27_TRUEDATE,
P0993ED7E.BOOL27_TRUEVISIT,
P0AD1FCF7.PRG0,
P0AD1FCF7.PRG0_LASTSTART_VISIT,
P0AD1FCF7.PRG0_LASTSTART_DATE,
P0AD1FCF7.PRG1,
P0AD1FCF7.PRG1_LASTSTART_VISIT,
P0AD1FCF7.PRG1_LASTSTART_DATE,
P0B4F15FE.BOOL0,
P0B4F15FE.BOOL0_NUMTRUE,
P0B4F15FE.BOOL0_TOTAL,
P0B4F15FE.BOOL0_TRUEDATE,
P0B4F15FE.BOOL0_TRUEVISIT,
P0B4F15FE.BOOL1,
P0B4F15FE.BOOL1_NUMTRUE,
P0B4F15FE.BOOL1_TOTAL,
P0B4F15FE.BOOL1_TRUEDATE,
P0B4F15FE.BOOL1_TRUEVISIT,
P0B4F15FE.BOOL2,
P0B4F15FE.BOOL2_NUMTRUE,
P0B4F15FE.BOOL2_TOTAL,
P0B4F15FE.BOOL2_TRUEDATE,
P0B4F15FE.BOOL2_TRUEVISIT,
P0B4F15FE.BOOL3,
P0B4F15FE.BOOL3_NUMTRUE,
P0B4F15FE.BOOL3_TOTAL,
P0B4F15FE.BOOL3_TRUEDATE,
P0B4F15FE.BOOL3_TRUEVISIT,
P0B4F15FE.BOOL4,
P0B4F15FE.BOOL4_NUMTRUE,
P0B4F15FE.BOOL4_TOTAL,
P0B4F15FE.BOOL4_TRUEDATE,
P0B4F15FE.BOOL4_TRUEVISIT,
P0B4F15FE.BOOL5,
P0B4F15FE.BOOL5_NUMTRUE,
P0B4F15FE.BOOL5_TOTAL,
P0B4F15FE.BOOL5_TRUEDATE,
P0B4F15FE.BOOL5_TRUEVISIT,
P0B4F15FE.BOOL6,
P0B4F15FE.BOOL6_NUMTRUE,
P0B4F15FE.BOOL6_TOTAL,
P0B4F15FE.BOOL6_TRUEDATE,
P0B4F15FE.BOOL6_TRUEVISIT,
P0B4F15FE.BOOL7,
P0B4F15FE.BOOL7_NUMTRUE,
P0B4F15FE.BOOL7_TOTAL,
P0B4F15FE.BOOL7_TRUEDATE,
P0B4F15FE.BOOL7_TRUEVISIT,
P0B4F15FE.BOOL8,
P0B4F15FE.BOOL8_NUMTRUE,
P0B4F15FE.BOOL8_TOTAL,
P0B4F15FE.BOOL8_TRUEDATE,
P0B4F15FE.BOOL8_TRUEVISIT,
P0B4F15FE.BOOL9,
P0B4F15FE.BOOL9_NUMTRUE,
P0B4F15FE.BOOL9_TOTAL,
P0B4F15FE.BOOL9_TRUEDATE,
P0B4F15FE.BOOL9_TRUEVISIT,
P0B4F15FE.BOOL10,
P0B4F15FE.BOOL10_NUMTRUE,
P0B4F15FE.BOOL10_TOTAL,
P0B4F15FE.BOOL10_TRUEDATE,
P0B4F15FE.BOOL10_TRUEVISIT,
P0B4F15FE.BOOL11,
P0B4F15FE.BOOL11_NUMTRUE,
P0B4F15FE.BOOL11_TOTAL,
P0B4F15FE.BOOL11_TRUEDATE,
P0B4F15FE.BOOL11_TRUEVISIT,
P0B4F15FE.BOOL12,
P0B4F15FE.BOOL12_NUMTRUE,
P0B4F15FE.BOOL12_TOTAL,
P0B4F15FE.BOOL12_TRUEDATE,
P0B4F15FE.BOOL12_TRUEVISIT,
P0B4F15FE.BOOL13,
P0B4F15FE.BOOL13_NUMTRUE,
P0B4F15FE.BOOL13_TOTAL,
P0B4F15FE.BOOL13_TRUEDATE,
P0B4F15FE.BOOL13_TRUEVISIT,
P0B4F15FE.BOOL14,
P0B4F15FE.BOOL14_NUMTRUE,
P0B4F15FE.BOOL14_TOTAL,
P0B4F15FE.BOOL14_TRUEDATE,
P0B4F15FE.BOOL14_TRUEVISIT,
P0B4F15FE.BOOL15,
P0B4F15FE.BOOL15_NUMTRUE,
P0B4F15FE.BOOL15_TOTAL,
P0B4F15FE.BOOL15_TRUEDATE,
P0B4F15FE.BOOL15_TRUEVISIT,
P0B4F15FE.BOOL16,
P0B4F15FE.BOOL16_NUMTRUE,
P0B4F15FE.BOOL16_TOTAL,
P0B4F15FE.BOOL16_TRUEDATE,
P0B4F15FE.BOOL16_TRUEVISIT,
P0B4F15FE.BOOL17,
P0B4F15FE.BOOL17_NUMTRUE,
P0B4F15FE.BOOL17_TOTAL,
P0B4F15FE.BOOL17_TRUEDATE,
P0B4F15FE.BOOL17_TRUEVISIT,
P0B4F15FE.BOOL18,
P0B4F15FE.BOOL18_NUMTRUE,
P0B4F15FE.BOOL18_TOTAL,
P0B4F15FE.BOOL18_TRUEDATE,
P0B4F15FE.BOOL18_TRUEVISIT,
P0B4F15FE.BOOL19,
P0B4F15FE.BOOL19_NUMTRUE,
P0B4F15FE.BOOL19_TOTAL,
P0B4F15FE.BOOL19_TRUEDATE,
P0B4F15FE.BOOL19_TRUEVISIT,
P0B4F15FE.BOOL20,
P0B4F15FE.BOOL20_NUMTRUE,
P0B4F15FE.BOOL20_TOTAL,
P0B4F15FE.BOOL20_TRUEDATE,
P0B4F15FE.BOOL20_TRUEVISIT,
P0B4F15FE.BOOL21,
P0B4F15FE.BOOL21_NUMTRUE,
P0B4F15FE.BOOL21_TOTAL,
P0B4F15FE.BOOL21_TRUEDATE,
P0B4F15FE.BOOL21_TRUEVISIT,
P0B4F15FE.BOOL22,
P0B4F15FE.BOOL22_NUMTRUE,
P0B4F15FE.BOOL22_TOTAL,
P0B4F15FE.BOOL22_TRUEDATE,
P0B4F15FE.BOOL22_TRUEVISIT,
P0B4F15FE.BOOL23,
P0B4F15FE.BOOL23_NUMTRUE,
P0B4F15FE.BOOL23_TOTAL,
P0B4F15FE.BOOL23_TRUEDATE,
P0B4F15FE.BOOL23_TRUEVISIT,
P0B4F15FE.BOOL24,
P0B4F15FE.BOOL24_NUMTRUE,
P0B4F15FE.BOOL24_TOTAL,
P0B4F15FE.BOOL24_TRUEDATE,
P0B4F15FE.BOOL24_TRUEVISIT,
P0B4F15FE.VISITOR_ID
FROM
bigw.PL_0B4F15FE AS P0B4F15FE
inner join bigw.PL_006C6132 AS P006C6132
on P0B4F15FE.VISITOR_ID = P006C6132.VISITOR_ID
inner join bigw.PL_011ABBBF AS P011ABBBF
on P0B4F15FE.VISITOR_ID = P011ABBBF.VISITOR_ID
inner join bigw.PL_0236B8D8 AS P0236B8D8
on P0B4F15FE.VISITOR_ID = P0236B8D8.VISITOR_ID
inner join bigw.PL_03BD6763 AS P03BD6763
on P0B4F15FE.VISITOR_ID = P03BD6763.VISITOR_ID
inner join bigw.PL_05507FBC AS P05507FBC
on P0B4F15FE.VISITOR_ID = P05507FBC.VISITOR_ID
inner join bigw.PL_0993ED7E AS P0993ED7E
on P0B4F15FE.VISITOR_ID = P0993ED7E.VISITOR_ID
inner join bigw.PL_0AD1FCF7 AS P0AD1FCF7
on P0B4F15FE.VISITOR_ID = P0AD1FCF7.VISITOR_ID
GO
I know it is a big massive join query. Each of this table is approx 40million records and indexed on the VISITOR_ID field clustered and ASC sorted.
This single query took me almost 22 hours to finish. and I need to improve it to at most 3-4 hours :/
Has anyone got into this kind of situation and find a work around to improve the query?
Cheers
Wilson
February 7, 2012 at 12:21 am
What is the recovery model of your database?
With such a huge query involving so much data, there will be quite some logging overhead. So minimize the logging by switching to simple recovery model.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 7, 2012 at 7:44 am
Wo there.
Approx 40 million rows in each table and a query with no WHERE clause. Why are you duplicating all of this data by inserting it into another table?
Whats the data size involved? By looking at a lot of the column names there could well be a lot ofbit columns. Have you presized the data and log files to remove the need to autogrow.
Koen Verbeeck (2/7/2012)
What is the recovery model of your database?With such a huge query involving so much data, there will be quite some logging overhead. So minimize the logging by switching to simple recovery model.
No point. There's going to be transaction logging issues regardless of the recovery model as it has to complete before the Tlog is checkpointed.
February 7, 2012 at 8:02 am
Few Questions:
•Do you really need all the columns in SELECT clause?
•7 Inner Joins with 40M records table and No WHERE condition. Do you need all data?
•What does it return? sp_spaceused '< Table_Name>'
Can you please post the execution plan? We prefer actual plans but for a query taking 22hrs, I won’t push for it.
February 7, 2012 at 11:52 am
MysteryJimbo (2/7/2012)
Koen Verbeeck (2/7/2012)
What is the recovery model of your database?With such a huge query involving so much data, there will be quite some logging overhead. So minimize the logging by switching to simple recovery model.
No point. There's going to be transaction logging issues regardless of the recovery model as it has to complete before the Tlog is checkpointed.
Ah yes, you're right.
That helps with lots of different transactions, not one long one.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 7, 2012 at 11:56 am
can we assume that there are no indexes on table bigw.PL0_NEW_ALL ?
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
February 7, 2012 at 3:48 pm
The p0 table is clustered index on VISITOR_ID ASC too.
The Recovery model is Simple. Whole data size is approx close to 301GB
Yes, I need all the data. Because we just change our production model and this is part of the plan to migrate from the old to the new production database model.
Yesterday I managed to make it run just a little bit over 3.5 hours (3 hours and 41 minutes to be exact) after free up some space on the server. It seems like not the query issue but space issue. I freed up almost 800GB on the server yesterday (where it only had 400GB left and now 1.1TB free space). My theory is, it took ages to run because of the amount of data to process is just ridiculously huge and it didn't have enough space to perform at the optimum level.
Any thought?
PS: I have attached the query plan too
Cheers
Wilson
February 7, 2012 at 4:05 pm
wilson_acong (2/7/2012)
The p0 table is clustered index on VISITOR_ID ASC too.The Recovery model is Simple. Whole data size is approx close to 301GB
Yes, I need all the data. Because we just change our production model and this is part of the plan to migrate from the old to the new production database model.
Yesterday I managed to make it run just a little bit over 3.5 hours (3 hours and 41 minutes to be exact) after free up some space on the server. It seems like not the query issue but space issue. I freed up almost 800GB on the server yesterday (where it only had 400GB left and now 1.1TB free space). My theory is, it took ages to run because of the amount of data to process is just ridiculously huge and it didn't have enough space to perform at the optimum level.
Any thought?
PS: I have attached the query plan too
Cheers
Wilson
A couple. First, pre-grow your database to the expected size you're going to need, log file too. don't have that occurring in the middle of this process.
Second,
I know it is a big massive join query. Each of this table is approx 40million records and indexed on the VISITOR_ID field clustered and ASC sorted.
Indexed doesn't mean Primary Keyed. Are there duplicate rows with visitorID in the subtables, or is this just a massive 1 to 1 join? That's going to throw wrenches in the works.
Third, check perfmon when this is running, check your pagefaults. Make sure you're not hammering the swapfile. If you are, you might be able to optimize this but putting in a wrapper loop to do a few hundred thousand VisitorIDs at a time simply by lowering the volume of stuff you're forcing through memory. Your logfile will thank you too.
Fourth, for next time, please use the code="sql" tag to wrap your code. It makes it SOOO much easier to read and not have to scroll a few hundred pages to get to the end of your post. 🙂
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
February 7, 2012 at 4:15 pm
Thanks Craig,
it was a good one to throw into wrapper and process couple hundred thousands of record each time.
all the table has VISITOR_ID as the primary key. So there will be no duplicate on VISITOR_ID. I have a separate process built in the old production model to monitor any duplicate VISITOR_ID in any of those table.
hmm.. "check your pagefaults. Make sure you're not hammering the swapfile." this sounds interesting would you mind elaborate how to perform that checking?
Cheers
Wilson
February 7, 2012 at 4:23 pm
wilson_acong (2/7/2012)
hmm.. "check your pagefaults. Make sure you're not hammering the swapfile." this sounds interesting would you mind elaborate how to perform that checking?
Sure. In perfmon (Performance Monitor) there's a counter called 'page fault'. A page fault is when you've used more memory then is available and it has to write the memory to disk temporarily. It stores that in the 'swapfile'.
During the process bring up that counter and monitor it. If it spikes/steadily increases, you're pushing the memory too far.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
Viewing 10 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply