I have a large union.
If I break it into its individual parts they all run quick. The
longest is the last select it takes 2 minutes to fetch all rows. When
I run the query below it does not come back for quite some time. 20
minutes. There are very few duplicates. When I run the sql's
individually the first two give no warning but the third
does(SQL0437W Performance of this complex query may be sub-optimal.
Reason code:"1". SQLSTATE=01602). If I run the first two by them
selves they work quick in 2 minutes. But if I run any of the first
SQL's with the last one it takes 20 minutes again. I have changed
the STMTHEAP to 25600 pages(100MB) but it caused other SQL's to become
bad and take upwards of 5 minutes to explain( I did not think this was
a viable solution since the third SQL with the bad access path by
itself it ran in 2 minutes). This one does as well. If I take the
individual third SQL statement it takes 4 minutes to prepare and then
runs in 3 seconds(Finally with the right access path, in my eyes).
Is there something that the optimizer does to look for like parts of
the SQL when there is a union do those like parts once?
Any help would be appreciated. Thanks,
(
SELECT
RTRIM(CHAR(RIGHT(ODS_WT_DEAL.BOOK_NM,4))),
( CASE WHEN ( ODS_WT_SCHDL_DEAL.SRC_CD ) NOT IN ('CSWS','PJM') AND
( ODS_WT_SCHDL_DEAL.SINK_CD ) NOT IN ('CSWS','PJM') THEN
'WT-Off'
WHEN ( ODS_WT_SCHDL_DEAL.SRC_CD ) IN ('CSWS','PJM') OR
( ODS_WT_SCHDL_DEAL.SINK_CD ) IN ('CSWS','PJM') THEN
'WT-On'
END ) || ' - ' ||
( Alias_ODS_AEE_BOOK_DESIG_WT_DEAL.BOOK_DESIGNATION_ NAME ),
ODS_WT_DEAL.DEAL_NR,
SUM(ABS(CASE WHEN ( ODS_WT_SCHDL_DEAL.SRC_CD ) IN ('CSWS','PJM')
THEN ODS_WT_SCHDL_ENRGY_PRFL_BLK.GEN_MW_QT
WHEN ( ODS_WT_SCHDL_DEAL.SINK_CD ) IN ('CSWS','PJM') THEN
ODS_WT_SCHDL_ENRGY_PRFL_BLK.LOAD_MW_QT
END)),
Alias_EDW_PERIOD_MWH_WT.CPT_PERIOD_DT,
ODS_WT_DEAL.TRAN_TYP_CD,
ODS_STLMT_CNTR_PRTY_XREF.CPRTY_CD,
ODS_WT_DEAL.DEAL_ID,
CHAR(ODS_WT_DEAL.DEAL_NR),
ODS_WT_DEAL.TRD_DT,
rtrim(ltrim(ODS_WT_DEAL.MKT1_NM)),
ODS_WT_DEAL.DEAL_TYP_TX,
RTRIM(ODS_WT_DEAL.TERM_TX),
Alias_EDW_PERIOD_MWH_WT.CPT_PERIOD_TS
FROM
DB2INSTB.ODS_WT_DEAL ODS_WT_DEAL,
DB2INSTB.ODS_WT_SCHDL_DEAL ODS_WT_SCHDL_DEAL,
DB2INSTB.ODS_AEE_BOOK_DESIGNATION Alias_ODS_AEE_BOOK_DESIG_WT_DEAL,
DB2INSTB.ODS_WT_SCHDL_ENRGY_PRFL_BLK ODS_WT_SCHDL_ENRGY_PRFL_BLK,
DB2INSTB.ODS_EDW_PERIOD Alias_EDW_PERIOD_MWH_WT,
DB2INSTB.ODS_STLMT_CNTR_PRTY_XREF ODS_STLMT_CNTR_PRTY_XREF,
DB2INSTB.ODS_WT_SCHDL_DEAL_CPRTY ODS_WT_SCHDL_DEAL_CPRTY,
DB2INSTB.ODS_AEE_BOOK Alias_ODS_AEE_BOOK_WT_DEAL
WHERE
( ODS_WT_SCHDL_DEAL.PHYS_DEAL_NR=ODS_WT_SCHDL_DEAL_C PRTY.PHYS_DEAL_NR )
AND ( ODS_WT_SCHDL_DEAL_CPRTY.DEAL_NR=ODS_WT_DEAL.DEAL_N R )
AND ( ODS_STLMT_CNTR_PRTY_XREF.SOURCE_CPRTY_CD=ODS_WT_DE AL.CPRTY_NM
AND ODS_STLMT_CNTR_PRTY_XREF.SOURCE_SYS_CD = 'WT' )
AND
( Alias_EDW_PERIOD_MWH_WT.GMT_PERIOD_TS=ODS_WT_SCHDL _ENRGY_PRFL_BLK.HOUR_ENDING_TS )
AND ( RTRIM(CHAR(RIGHT(ODS_WT_DEAL.BOOK_NM,
4)))=Alias_ODS_AEE_BOOK_WT_DEAL.BOOK_NAME )
AND
( Alias_ODS_AEE_BOOK_WT_DEAL.BOOK_ID=Alias_ODS_AEE_B OOK_DESIG_WT_DEAL.BOOK_ID )
AND
( ODS_WT_SCHDL_ENRGY_PRFL_BLK.PHYS_DEAL_NR=ODS_WT_SC HDL_DEAL_CPRTY.PHYS_DEAL_NR )
AND (
( ( Alias_EDW_PERIOD_MWH_WT.CPT_PERIOD_DT ) between '03/01/2007'
and '03/31/2007' AND (Alias_EDW_PERIOD_MWH_WT.CPT_PERIOD_DT >=
Alias_ODS_AEE_BOOK_DESIG_WT_DEAL.START_DATE AND
Alias_EDW_PERIOD_MWH_WT.CPT_PERIOD_DT <=
Alias_ODS_AEE_BOOK_DESIG_WT_DEAL.STOP_DATE )
AND
ODS_WT_SCHDL_ENRGY_PRFL_BLK.HOUR_ENDING_DT >= date('03/01/2007') -1
day and ODS_WT_SCHDL_ENRGY_PRFL_BLK.HOUR_ENDING_DT <=
date('03/31/2007') + 1 day
and ( Alias_EDW_PERIOD_MWH_WT.CPT_PERIOD_DT ) BETWEEN
ODS_STLMT_CNTR_PRTY_XREF.SOURCE_START_DT AND
ODS_STLMT_CNTR_PRTY_XREF.SOURCE_END_DT )
AND ( ( ODS_STLMT_CNTR_PRTY_XREF.CPRTY_CD ) NOT IN
('AEP','AEPGEN','AEPLOAD','AEPTCC','AEPTNC','PJM
OPRES','ERCOT','QFOXYCHEM','',' ') AND
( ODS_STLMT_CNTR_PRTY_XREF.CPRTY_CD ) NOT IN '%' )
AND ( CASE WHEN ( ODS_WT_SCHDL_DEAL.SRC_CD ) NOT IN ('CSWS','PJM')
AND ( ODS_WT_SCHDL_DEAL.SINK_CD ) NOT IN ('CSWS','PJM') THEN
'WT-Off'
WHEN ( ODS_WT_SCHDL_DEAL.SRC_CD ) IN ('CSWS','PJM') OR
( ODS_WT_SCHDL_DEAL.SINK_CD ) IN ('CSWS','PJM') THEN
'WT-On'
END ) || ' - ' ||
( Alias_ODS_AEE_BOOK_DESIG_WT_DEAL.BOOK_DESIGNATION_ NAME ) IN ('WT-
On - PE', 'WT-On - PW')
AND ODS_WT_DEAL.STATUS_CD < 'VOIDED'
AND ODS_WT_SCHDL_DEAL.STAT_CD < 'VOIDED'
AND ODS_WT_DEAL.DEAL_TYP_TX < 'Transmission'
)
GROUP BY
RTRIM(CHAR(RIGHT(ODS_WT_DEAL.BOOK_NM,4))),
( CASE WHEN ( ODS_WT_SCHDL_DEAL.SRC_CD ) NOT IN ('CSWS','PJM') AND
( ODS_WT_SCHDL_DEAL.SINK_CD ) NOT IN ('CSWS','PJM') THEN
'WT-Off'
WHEN ( ODS_WT_SCHDL_DEAL.SRC_CD ) IN ('CSWS','PJM') OR
( ODS_WT_SCHDL_DEAL.SINK_CD ) IN ('CSWS','PJM') THEN
'WT-On'
END ) || ' - ' ||
( Alias_ODS_AEE_BOOK_DESIG_WT_DEAL.BOOK_DESIGNATION_ NAME ),
ODS_WT_DEAL.DEAL_NR,
Alias_EDW_PERIOD_MWH_WT.CPT_PERIOD_DT,
ODS_WT_DEAL.TRAN_TYP_CD,
ODS_STLMT_CNTR_PRTY_XREF.CPRTY_CD,
ODS_WT_DEAL.DEAL_ID,
CHAR(ODS_WT_DEAL.DEAL_NR),
ODS_WT_DEAL.TRD_DT,
rtrim(ltrim(ODS_WT_DEAL.MKT1_NM)),
ODS_WT_DEAL.DEAL_TYP_TX,
RTRIM(ODS_WT_DEAL.TERM_TX),
Alias_EDW_PERIOD_MWH_WT.CPT_PERIOD_TS
UNION
(
SELECT
RTRIM(CHAR(RIGHT(ODS_WT_DEAL.BOOK_NM,4))),
'WT' || ' - ' ||
( Alias_ODS_AEE_BOOK_DESIG_WT_DEAL.BOOK_DESIGNATION_ NAME ),
ODS_WT_DEAL.DEAL_NR,
ABS(ODS_WT_DEAL_ENGRY_PRFL_BLK.EP_MW_QT),
Alias_EDW_PERIOD_Price_WT.CPT_PERIOD_DT,
ODS_WT_DEAL.TRAN_TYP_CD,
ODS_STLMT_CNTR_PRTY_XREF.CPRTY_CD,
ODS_WT_DEAL.DEAL_ID,
CHAR(ODS_WT_DEAL.DEAL_NR),
ODS_WT_DEAL.TRD_DT,
rtrim(ltrim(ODS_WT_DEAL.MKT1_NM)),
ODS_WT_DEAL.DEAL_TYP_TX,
RTRIM(ODS_WT_DEAL.TERM_TX),
Alias_EDW_PERIOD_Price_WT.CPT_PERIOD_TS
FROM
DB2INSTB.ODS_WT_DEAL ODS_WT_DEAL,
DB2INSTB.ODS_AEE_BOOK_DESIGNATION Alias_ODS_AEE_BOOK_DESIG_WT_DEAL,
DB2INSTB.ODS_WT_DEAL_ENGRY_PRFL_BLK ODS_WT_DEAL_ENGRY_PRFL_BLK,
DB2INSTB.ODS_EDW_PERIOD Alias_EDW_PERIOD_Price_WT,
DB2INSTB.ODS_STLMT_CNTR_PRTY_XREF ODS_STLMT_CNTR_PRTY_XREF,
DB2INSTB.ODS_AEE_BOOK Alias_ODS_AEE_BOOK_WT_DEAL
WHERE
( ODS_STLMT_CNTR_PRTY_XREF.SOURCE_CPRTY_CD=ODS_WT_DE AL.CPRTY_NM AND
ODS_STLMT_CNTR_PRTY_XREF.SOURCE_SYS_CD = 'WT' )
AND
( Alias_EDW_PERIOD_Price_WT.GMT_PERIOD_TS=ODS_WT_DEA L_ENGRY_PRFL_BLK.HOUR_ENDING_TS )
AND ( RTRIM(CHAR(RIGHT(ODS_WT_DEAL.BOOK_NM,
4)))=Alias_ODS_AEE_BOOK_WT_DEAL.BOOK_NAME )
AND
( Alias_ODS_AEE_BOOK_WT_DEAL.BOOK_ID=Alias_ODS_AEE_B OOK_DESIG_WT_DEAL.BOOK_ID )
AND ( ODS_WT_DEAL_ENGRY_PRFL_BLK.DEAL_NR=ODS_WT_DEAL.DEA L_NR )
AND (
( ( Alias_EDW_PERIOD_Price_WT.CPT_PERIOD_DT ) between '03/01/2007'
and '03/31/2007' AND (( Alias_EDW_PERIOD_Price_WT.CPT_PERIOD_DT ) >=
Alias_ODS_AEE_BOOK_DESIG_WT_DEAL.START_DATE AND
( Alias_EDW_PERIOD_Price_WT.CPT_PERIOD_DT ) <=
Alias_ODS_AEE_BOOK_DESIG_WT_DEAL.STOP_DATE )
AND
ODS_WT_DEAL_ENGRY_PRFL_BLK.HOUR_ENDING_DT >= date('03/01/2007') -1
day and ODS_WT_DEAL_ENGRY_PRFL_BLK.HOUR_ENDING_DT <=
date('03/31/2007') + 1 day
and ( Alias_EDW_PERIOD_Price_WT.CPT_PERIOD_DT ) BETWEEN
ODS_STLMT_CNTR_PRTY_XREF.SOURCE_START_DT AND
ODS_STLMT_CNTR_PRTY_XREF.SOURCE_END_DT )
AND ( ( ODS_STLMT_CNTR_PRTY_XREF.CPRTY_CD ) NOT IN
('AEP','AEPGEN','AEPLOAD','AEPTCC','AEPTNC','PJM
OPRES','ERCOT','QFOXYCHEM','',' ') AND
( ODS_STLMT_CNTR_PRTY_XREF.CPRTY_CD ) NOT IN '%' )
AND 'WT' || ' - ' ||
( Alias_ODS_AEE_BOOK_DESIG_WT_DEAL.BOOK_DESIGNATION_ NAME ) IN ('WT -
PE', 'WT - PW')
AND ODS_WT_DEAL.DEAL_TYP_TX < 'Transmission'
AND ODS_WT_DEAL.STATUS_CD < 'VOIDED'
)
UNION
SELECT
RTRIM(CHAR(RIGHT(ODS_WT_DEAL.BOOK_NM,4))),
CASE WHEN Alias_ODS_AEE_BOOK_DESIG_WT_DEAL.BOOK_DESIGNATION_ NAME =
'PW'
AND ( ODS_WT_SCHDL_DEAL.SRC_CD ) IN ('CSWS','PJM') THEN 'WT-On - PW'
WHEN Alias_ODS_AEE_BOOK_DESIG_WT_DEAL.BOOK_DESIGNATION_ NAME = 'PE'
AND ( ODS_WT_SCHDL_DEAL.SRC_CD ) IN ('CSWS','PJM') THEN 'WT-On - PE'
END,
ODS_WT_SCHDL_DEAL.PHYS_DEAL_NR,
SUM(ODS_WT_SCHDL_LPRFL_BLK.BLK_MW*-1),
ODS_WT_SCHDL_LPRFL_BLK.CPT_PERIOD_DT,
ODS_WT_DEAL.TRAN_TYP_CD,
ODS_STLMT_CNTR_PRTY_XREF.CPRTY_CD,
ODS_WT_DEAL.DEAL_ID,
CHAR(ODS_WT_DEAL.DEAL_NR),
ODS_WT_DEAL.TRD_DT,
rtrim(ltrim(ODS_WT_DEAL.MKT1_NM)),
ODS_WT_DEAL.DEAL_TYP_TX,
RTRIM(ODS_WT_DEAL.TERM_TX),
ODS_WT_SCHDL_LPRFL_BLK.CPT_PERIOD_TS
FROM
DB2INSTB.ODS_WT_DEAL ODS_WT_DEAL,
DB2INSTB.ODS_AEE_BOOK_DESIGNATION Alias_ODS_AEE_BOOK_DESIG_WT_DEAL,
DB2INSTB.ODS_WT_SCHDL_DEAL ODS_WT_SCHDL_DEAL,
DB2INSTB.ODS_WT_SCHDL_LPRFL_BLK_VW ODS_WT_SCHDL_LPRFL_BLK,
DB2INSTB.ODS_STLMT_CNTR_PRTY_XREF ODS_STLMT_CNTR_PRTY_XREF,
DB2INSTB.ODS_WT_SCHDL_TPRFL_RSRVN ODS_WT_SCHDL_TPRFL_RSRVN,
DB2INSTB.ODS_AEE_BOOK Alias_ODS_AEE_BOOK_WT_DEAL,
DB2INSTB.ODS_WT_SCHDL_DEAL_CPRTY ODS_WT_SCHDL_DEAL_CPRTY,
DB2INSTB.ODS_WT_SCHDL_DEAL_LPRFL ODS_WT_SCHDL_DEAL_LPRFL,
DB2INSTB.ODS_WT_SCHDL_DEAL_TPRFL ODS_WT_SCHDL_DEAL_TPRFL
WHERE
( ODS_WT_SCHDL_DEAL.PHYS_DEAL_NR=ODS_WT_SCHDL_DEAL_C PRTY.PHYS_DEAL_NR )
AND ( ODS_WT_SCHDL_DEAL_CPRTY.DEAL_NR=ODS_WT_DEAL.DEAL_N R )
AND ( ODS_STLMT_CNTR_PRTY_XREF.SOURCE_CPRTY_CD=ODS_WT_DE AL.CPRTY_NM
AND ODS_STLMT_CNTR_PRTY_XREF.SOURCE_SYS_CD = 'WT' )
AND
( ODS_WT_SCHDL_DEAL_LPRFL.PHYS_DEAL_NR=ODS_WT_SCHDL_ DEAL.PHYS_DEAL_NR )
AND
( ODS_WT_SCHDL_DEAL_LPRFL.PHYS_DEAL_NR=ODS_WT_SCHDL_ LPRFL_BLK.PHYS_DEAL_NR
and
ODS_WT_SCHDL_DEAL_LPRFL.LPRFL_ID=ODS_WT_SCHDL_LPRF L_BLK.LPRFL_ID )
AND
( ODS_WT_SCHDL_DEAL_LPRFL.PHYS_DEAL_NR=ODS_WT_SCHDL_ DEAL_TPRFL.PHYS_DEAL_NR )
AND
( ODS_WT_SCHDL_DEAL_LPRFL.TRNMT_PRVDR_NM=ODS_WT_SCHD L_DEAL_TPRFL.TRNMT_PRVDR_NM )
AND
( ODS_WT_SCHDL_DEAL_TPRFL.PHYS_DEAL_NR=ODS_WT_SCHDL_ TPRFL_RSRVN.PHYS_DEAL_NR )
AND
( ODS_WT_SCHDL_DEAL_TPRFL.SCHDL_DEAL_PRFL_ID=ODS_WT_ SCHDL_TPRFL_RSRVN.SCHDL_DEAL_PRFL_ID )
AND
( ODS_WT_SCHDL_DEAL_TPRFL.TRANS_PRFL_ID=ODS_WT_SCHDL _TPRFL_RSRVN.TRANS_PRFL_ID )
AND ( RTRIM(CHAR(RIGHT(ODS_WT_DEAL.BOOK_NM,
4)))=Alias_ODS_AEE_BOOK_WT_DEAL.BOOK_NAME )
AND
( Alias_ODS_AEE_BOOK_WT_DEAL.BOOK_ID=Alias_ODS_AEE_B OOK_DESIG_WT_DEAL.BOOK_ID )
AND (
( ( ODS_STLMT_CNTR_PRTY_XREF.CPRTY_CD ) NOT IN
('AEP','AEPGEN','AEPLOAD','AEPTCC','AEPTNC','PJM
OPRES','ERCOT','QFOXYCHEM','',' ') AND
( ODS_STLMT_CNTR_PRTY_XREF.CPRTY_CD ) NOT IN '%' )
AND ( ( ODS_WT_SCHDL_LPRFL_BLK.CPT_PERIOD_DT ) between '03/01/2007'
and '03/31/2007' AND (ODS_WT_SCHDL_LPRFL_BLK.CPT_PERIOD_DT >=
Alias_ODS_AEE_BOOK_DESIG_WT_DEAL.START_DATE AND
ODS_WT_SCHDL_LPRFL_BLK.CPT_PERIOD_DT <=
Alias_ODS_AEE_BOOK_DESIG_WT_DEAL.STOP_DATE) and
ODS_WT_SCHDL_LPRFL_BLK.HOUR_ENDING_DT >= date('03/01/2007') -1 day
and ODS_WT_SCHDL_LPRFL_BLK.HOUR_ENDING_DT<= date('03/31/2007') + 1
day
and ( Alias_EDW_PERIOD_WT_LPrfl.CPT_PERIOD_DT ) BETWEEN
ODS_STLMT_CNTR_PRTY_XREF.SOURCE_START_DT AND
ODS_STLMT_CNTR_PRTY_XREF.SOURCE_END_DT )
AND ODS_WT_SCHDL_DEAL.STAT_CD < 'VOIDED'
AND CASE WHEN
Alias_ODS_AEE_BOOK_DESIG_WT_DEAL.BOOK_DESIGNATION_ NAME = 'PW'
AND ( ODS_WT_SCHDL_DEAL.SRC_CD ) IN ('CSWS','PJM') THEN 'WT-On - PW'
WHEN Alias_ODS_AEE_BOOK_DESIG_WT_DEAL.BOOK_DESIGNATION_ NAME = 'PE'
AND ( ODS_WT_SCHDL_DEAL.SRC_CD ) IN ('CSWS','PJM') THEN 'WT-On - PE'
END IN ('WT-On - PE', 'WT-On - PW')
AND ODS_WT_DEAL.DEAL_TYP_TX < 'Transmission'
AND ODS_WT_DEAL.STATUS_CD < 'VOIDED'
AND ODS_WT_SCHDL_TPRFL_RSRVN.OWNER_NM IN ('AEPMEA', 'CSWMEO')
)
GROUP BY
RTRIM(CHAR(RIGHT(ODS_WT_DEAL.BOOK_NM,4))),
CASE WHEN Alias_ODS_AEE_BOOK_DESIG_WT_DEAL.BOOK_DESIGNATION_ NAME =
'PW'
AND ( ODS_WT_SCHDL_DEAL.SRC_CD ) IN ('CSWS','PJM') THEN 'WT-On - PW'
WHEN Alias_ODS_AEE_BOOK_DESIG_WT_DEAL.BOOK_DESIGNATION_ NAME = 'PE'
AND ( ODS_WT_SCHDL_DEAL.SRC_CD ) IN ('CSWS','PJM') THEN 'WT-On - PE'
END,
ODS_WT_SCHDL_DEAL.PHYS_DEAL_NR,
ODS_WT_SCHDL_LPRFL_BLK.CPT_PERIOD_DT,
ODS_WT_DEAL.TRAN_TYP_CD,
ODS_STLMT_CNTR_PRTY_XREF.CPRTY_CD,
ODS_WT_DEAL.DEAL_ID,
CHAR(ODS_WT_DEAL.DEAL_NR),
ODS_WT_DEAL.TRD_DT,
rtrim(ltrim(ODS_WT_DEAL.MKT1_NM)),
ODS_WT_DEAL.DEAL_TYP_TX,
RTRIM(ODS_WT_DEAL.TERM_TX),
ODS_WT_SCHDL_LPRFL_BLK.CPT_PERIOD_TS
)
);
2  2177 
You are using UNIONs (vs UNION ALL) to tie the three parts together
which helps make this a very large complicated statement to the
optimizer. Taking four minutes to optimize a query that can run in two
minutes probably isn't cost effective either.
Without trying to analyze your SQL, there are two simple things to try:
1. Try adjusting the optimization level for the statement. You'll need
to strike a balance between the time spent optimizing and the execution
time.
2. Create a temporary table that matches your SELECT columns and
populate it using three independent SELECT statements. Do a SELECT
DISTINCT from the temporary table to get your final results then delete
the contents of it. Performance can be improved by eliminating logging
by setting up the temporary table as "not logged initially". You'll have
to do all of the work on the table in a single transaction to make "not
logged initially" work.
Phil Sherman ja*********@aep.com wrote:
I have a large union.
If I break it into its individual parts they all run quick. The
longest is the last select it takes 2 minutes to fetch all rows. When
I run the query below it does not come back for quite some time. 20
minutes. There are very few duplicates. When I run the sql's
individually the first two give no warning but the third
does(SQL0437W Performance of this complex query may be sub-optimal.
Reason code:"1". SQLSTATE=01602). If I run the first two by them
selves they work quick in 2 minutes. But if I run any of the first
SQL's with the last one it takes 20 minutes again. I have changed
the STMTHEAP to 25600 pages(100MB) but it caused other SQL's to become
bad and take upwards of 5 minutes to explain( I did not think this was
a viable solution since the third SQL with the bad access path by
itself it ran in 2 minutes). This one does as well. If I take the
individual third SQL statement it takes 4 minutes to prepare and then
runs in 3 seconds(Finally with the right access path, in my eyes).
Is there something that the optimizer does to look for like parts of
the SQL when there is a union do those like parts once?
Any help would be appreciated. Thanks,
(
SELECT
RTRIM(CHAR(RIGHT(ODS_WT_DEAL.BOOK_NM,4))),
( CASE WHEN ( ODS_WT_SCHDL_DEAL.SRC_CD ) NOT IN ('CSWS','PJM') AND
( ODS_WT_SCHDL_DEAL.SINK_CD ) NOT IN ('CSWS','PJM') THEN
'WT-Off'
WHEN ( ODS_WT_SCHDL_DEAL.SRC_CD ) IN ('CSWS','PJM') OR
( ODS_WT_SCHDL_DEAL.SINK_CD ) IN ('CSWS','PJM') THEN
'WT-On'
END ) || ' - ' ||
( Alias_ODS_AEE_BOOK_DESIG_WT_DEAL.BOOK_DESIGNATION_ NAME ),
ODS_WT_DEAL.DEAL_NR,
SUM(ABS(CASE WHEN ( ODS_WT_SCHDL_DEAL.SRC_CD ) IN ('CSWS','PJM')
THEN ODS_WT_SCHDL_ENRGY_PRFL_BLK.GEN_MW_QT
WHEN ( ODS_WT_SCHDL_DEAL.SINK_CD ) IN ('CSWS','PJM') THEN
ODS_WT_SCHDL_ENRGY_PRFL_BLK.LOAD_MW_QT
END)),
Alias_EDW_PERIOD_MWH_WT.CPT_PERIOD_DT,
ODS_WT_DEAL.TRAN_TYP_CD,
ODS_STLMT_CNTR_PRTY_XREF.CPRTY_CD,
ODS_WT_DEAL.DEAL_ID,
CHAR(ODS_WT_DEAL.DEAL_NR),
ODS_WT_DEAL.TRD_DT,
rtrim(ltrim(ODS_WT_DEAL.MKT1_NM)),
ODS_WT_DEAL.DEAL_TYP_TX,
RTRIM(ODS_WT_DEAL.TERM_TX),
Alias_EDW_PERIOD_MWH_WT.CPT_PERIOD_TS
FROM
DB2INSTB.ODS_WT_DEAL ODS_WT_DEAL,
DB2INSTB.ODS_WT_SCHDL_DEAL ODS_WT_SCHDL_DEAL,
DB2INSTB.ODS_AEE_BOOK_DESIGNATION Alias_ODS_AEE_BOOK_DESIG_WT_DEAL,
DB2INSTB.ODS_WT_SCHDL_ENRGY_PRFL_BLK ODS_WT_SCHDL_ENRGY_PRFL_BLK,
DB2INSTB.ODS_EDW_PERIOD Alias_EDW_PERIOD_MWH_WT,
DB2INSTB.ODS_STLMT_CNTR_PRTY_XREF ODS_STLMT_CNTR_PRTY_XREF,
DB2INSTB.ODS_WT_SCHDL_DEAL_CPRTY ODS_WT_SCHDL_DEAL_CPRTY,
DB2INSTB.ODS_AEE_BOOK Alias_ODS_AEE_BOOK_WT_DEAL
WHERE
( ODS_WT_SCHDL_DEAL.PHYS_DEAL_NR=ODS_WT_SCHDL_DEAL_C PRTY.PHYS_DEAL_NR )
AND ( ODS_WT_SCHDL_DEAL_CPRTY.DEAL_NR=ODS_WT_DEAL.DEAL_N R )
AND ( ODS_STLMT_CNTR_PRTY_XREF.SOURCE_CPRTY_CD=ODS_WT_DE AL.CPRTY_NM
AND ODS_STLMT_CNTR_PRTY_XREF.SOURCE_SYS_CD = 'WT' )
AND
( Alias_EDW_PERIOD_MWH_WT.GMT_PERIOD_TS=ODS_WT_SCHDL _ENRGY_PRFL_BLK.HOUR_ENDING_TS )
AND ( RTRIM(CHAR(RIGHT(ODS_WT_DEAL.BOOK_NM,
4)))=Alias_ODS_AEE_BOOK_WT_DEAL.BOOK_NAME )
AND
( Alias_ODS_AEE_BOOK_WT_DEAL.BOOK_ID=Alias_ODS_AEE_B OOK_DESIG_WT_DEAL.BOOK_ID )
AND
( ODS_WT_SCHDL_ENRGY_PRFL_BLK.PHYS_DEAL_NR=ODS_WT_SC HDL_DEAL_CPRTY.PHYS_DEAL_NR )
AND (
( ( Alias_EDW_PERIOD_MWH_WT.CPT_PERIOD_DT ) between '03/01/2007'
and '03/31/2007' AND (Alias_EDW_PERIOD_MWH_WT.CPT_PERIOD_DT >=
Alias_ODS_AEE_BOOK_DESIG_WT_DEAL.START_DATE AND
Alias_EDW_PERIOD_MWH_WT.CPT_PERIOD_DT <=
Alias_ODS_AEE_BOOK_DESIG_WT_DEAL.STOP_DATE )
AND
ODS_WT_SCHDL_ENRGY_PRFL_BLK.HOUR_ENDING_DT >= date('03/01/2007') -1
day and ODS_WT_SCHDL_ENRGY_PRFL_BLK.HOUR_ENDING_DT <=
date('03/31/2007') + 1 day
and ( Alias_EDW_PERIOD_MWH_WT.CPT_PERIOD_DT ) BETWEEN
ODS_STLMT_CNTR_PRTY_XREF.SOURCE_START_DT AND
ODS_STLMT_CNTR_PRTY_XREF.SOURCE_END_DT )
AND ( ( ODS_STLMT_CNTR_PRTY_XREF.CPRTY_CD ) NOT IN
('AEP','AEPGEN','AEPLOAD','AEPTCC','AEPTNC','PJM
OPRES','ERCOT','QFOXYCHEM','',' ') AND
( ODS_STLMT_CNTR_PRTY_XREF.CPRTY_CD ) NOT IN '%' )
AND ( CASE WHEN ( ODS_WT_SCHDL_DEAL.SRC_CD ) NOT IN ('CSWS','PJM')
AND ( ODS_WT_SCHDL_DEAL.SINK_CD ) NOT IN ('CSWS','PJM') THEN
'WT-Off'
WHEN ( ODS_WT_SCHDL_DEAL.SRC_CD ) IN ('CSWS','PJM') OR
( ODS_WT_SCHDL_DEAL.SINK_CD ) IN ('CSWS','PJM') THEN
'WT-On'
END ) || ' - ' ||
( Alias_ODS_AEE_BOOK_DESIG_WT_DEAL.BOOK_DESIGNATION_ NAME ) IN ('WT-
On - PE', 'WT-On - PW')
AND ODS_WT_DEAL.STATUS_CD < 'VOIDED'
AND ODS_WT_SCHDL_DEAL.STAT_CD < 'VOIDED'
AND ODS_WT_DEAL.DEAL_TYP_TX < 'Transmission'
)
GROUP BY
RTRIM(CHAR(RIGHT(ODS_WT_DEAL.BOOK_NM,4))),
( CASE WHEN ( ODS_WT_SCHDL_DEAL.SRC_CD ) NOT IN ('CSWS','PJM') AND
( ODS_WT_SCHDL_DEAL.SINK_CD ) NOT IN ('CSWS','PJM') THEN
'WT-Off'
WHEN ( ODS_WT_SCHDL_DEAL.SRC_CD ) IN ('CSWS','PJM') OR
( ODS_WT_SCHDL_DEAL.SINK_CD ) IN ('CSWS','PJM') THEN
'WT-On'
END ) || ' - ' ||
( Alias_ODS_AEE_BOOK_DESIG_WT_DEAL.BOOK_DESIGNATION_ NAME ),
ODS_WT_DEAL.DEAL_NR,
Alias_EDW_PERIOD_MWH_WT.CPT_PERIOD_DT,
ODS_WT_DEAL.TRAN_TYP_CD,
ODS_STLMT_CNTR_PRTY_XREF.CPRTY_CD,
ODS_WT_DEAL.DEAL_ID,
CHAR(ODS_WT_DEAL.DEAL_NR),
ODS_WT_DEAL.TRD_DT,
rtrim(ltrim(ODS_WT_DEAL.MKT1_NM)),
ODS_WT_DEAL.DEAL_TYP_TX,
RTRIM(ODS_WT_DEAL.TERM_TX),
Alias_EDW_PERIOD_MWH_WT.CPT_PERIOD_TS
UNION
(
SELECT
RTRIM(CHAR(RIGHT(ODS_WT_DEAL.BOOK_NM,4))),
'WT' || ' - ' ||
( Alias_ODS_AEE_BOOK_DESIG_WT_DEAL.BOOK_DESIGNATION_ NAME ),
ODS_WT_DEAL.DEAL_NR,
ABS(ODS_WT_DEAL_ENGRY_PRFL_BLK.EP_MW_QT),
Alias_EDW_PERIOD_Price_WT.CPT_PERIOD_DT,
ODS_WT_DEAL.TRAN_TYP_CD,
ODS_STLMT_CNTR_PRTY_XREF.CPRTY_CD,
ODS_WT_DEAL.DEAL_ID,
CHAR(ODS_WT_DEAL.DEAL_NR),
ODS_WT_DEAL.TRD_DT,
rtrim(ltrim(ODS_WT_DEAL.MKT1_NM)),
ODS_WT_DEAL.DEAL_TYP_TX,
RTRIM(ODS_WT_DEAL.TERM_TX),
Alias_EDW_PERIOD_Price_WT.CPT_PERIOD_TS
FROM
DB2INSTB.ODS_WT_DEAL ODS_WT_DEAL,
DB2INSTB.ODS_AEE_BOOK_DESIGNATION Alias_ODS_AEE_BOOK_DESIG_WT_DEAL,
DB2INSTB.ODS_WT_DEAL_ENGRY_PRFL_BLK ODS_WT_DEAL_ENGRY_PRFL_BLK,
DB2INSTB.ODS_EDW_PERIOD Alias_EDW_PERIOD_Price_WT,
DB2INSTB.ODS_STLMT_CNTR_PRTY_XREF ODS_STLMT_CNTR_PRTY_XREF,
DB2INSTB.ODS_AEE_BOOK Alias_ODS_AEE_BOOK_WT_DEAL
WHERE
( ODS_STLMT_CNTR_PRTY_XREF.SOURCE_CPRTY_CD=ODS_WT_DE AL.CPRTY_NM AND
ODS_STLMT_CNTR_PRTY_XREF.SOURCE_SYS_CD = 'WT' )
AND
( Alias_EDW_PERIOD_Price_WT.GMT_PERIOD_TS=ODS_WT_DEA L_ENGRY_PRFL_BLK.HOUR_ENDING_TS )
AND ( RTRIM(CHAR(RIGHT(ODS_WT_DEAL.BOOK_NM,
4)))=Alias_ODS_AEE_BOOK_WT_DEAL.BOOK_NAME )
AND
( Alias_ODS_AEE_BOOK_WT_DEAL.BOOK_ID=Alias_ODS_AEE_B OOK_DESIG_WT_DEAL.BOOK_ID )
AND ( ODS_WT_DEAL_ENGRY_PRFL_BLK.DEAL_NR=ODS_WT_DEAL.DEA L_NR )
AND (
( ( Alias_EDW_PERIOD_Price_WT.CPT_PERIOD_DT ) between '03/01/2007'
and '03/31/2007' AND (( Alias_EDW_PERIOD_Price_WT.CPT_PERIOD_DT ) >=
Alias_ODS_AEE_BOOK_DESIG_WT_DEAL.START_DATE AND
( Alias_EDW_PERIOD_Price_WT.CPT_PERIOD_DT ) <=
Alias_ODS_AEE_BOOK_DESIG_WT_DEAL.STOP_DATE )
AND
ODS_WT_DEAL_ENGRY_PRFL_BLK.HOUR_ENDING_DT >= date('03/01/2007') -1
day and ODS_WT_DEAL_ENGRY_PRFL_BLK.HOUR_ENDING_DT <=
date('03/31/2007') + 1 day
and ( Alias_EDW_PERIOD_Price_WT.CPT_PERIOD_DT ) BETWEEN
ODS_STLMT_CNTR_PRTY_XREF.SOURCE_START_DT AND
ODS_STLMT_CNTR_PRTY_XREF.SOURCE_END_DT )
AND ( ( ODS_STLMT_CNTR_PRTY_XREF.CPRTY_CD ) NOT IN
('AEP','AEPGEN','AEPLOAD','AEPTCC','AEPTNC','PJM
OPRES','ERCOT','QFOXYCHEM','',' ') AND
( ODS_STLMT_CNTR_PRTY_XREF.CPRTY_CD ) NOT IN '%' )
AND 'WT' || ' - ' ||
( Alias_ODS_AEE_BOOK_DESIG_WT_DEAL.BOOK_DESIGNATION_ NAME ) IN ('WT -
PE', 'WT - PW')
AND ODS_WT_DEAL.DEAL_TYP_TX < 'Transmission'
AND ODS_WT_DEAL.STATUS_CD < 'VOIDED'
)
UNION
SELECT
RTRIM(CHAR(RIGHT(ODS_WT_DEAL.BOOK_NM,4))),
CASE WHEN Alias_ODS_AEE_BOOK_DESIG_WT_DEAL.BOOK_DESIGNATION_ NAME =
'PW'
AND ( ODS_WT_SCHDL_DEAL.SRC_CD ) IN ('CSWS','PJM') THEN 'WT-On - PW'
WHEN Alias_ODS_AEE_BOOK_DESIG_WT_DEAL.BOOK_DESIGNATION_ NAME = 'PE'
AND ( ODS_WT_SCHDL_DEAL.SRC_CD ) IN ('CSWS','PJM') THEN 'WT-On - PE'
END,
ODS_WT_SCHDL_DEAL.PHYS_DEAL_NR,
SUM(ODS_WT_SCHDL_LPRFL_BLK.BLK_MW*-1),
ODS_WT_SCHDL_LPRFL_BLK.CPT_PERIOD_DT,
ODS_WT_DEAL.TRAN_TYP_CD,
ODS_STLMT_CNTR_PRTY_XREF.CPRTY_CD,
ODS_WT_DEAL.DEAL_ID,
CHAR(ODS_WT_DEAL.DEAL_NR),
ODS_WT_DEAL.TRD_DT,
rtrim(ltrim(ODS_WT_DEAL.MKT1_NM)),
ODS_WT_DEAL.DEAL_TYP_TX,
RTRIM(ODS_WT_DEAL.TERM_TX),
ODS_WT_SCHDL_LPRFL_BLK.CPT_PERIOD_TS
FROM
DB2INSTB.ODS_WT_DEAL ODS_WT_DEAL,
DB2INSTB.ODS_AEE_BOOK_DESIGNATION Alias_ODS_AEE_BOOK_DESIG_WT_DEAL,
DB2INSTB.ODS_WT_SCHDL_DEAL ODS_WT_SCHDL_DEAL,
DB2INSTB.ODS_WT_SCHDL_LPRFL_BLK_VW ODS_WT_SCHDL_LPRFL_BLK,
DB2INSTB.ODS_STLMT_CNTR_PRTY_XREF ODS_STLMT_CNTR_PRTY_XREF,
DB2INSTB.ODS_WT_SCHDL_TPRFL_RSRVN ODS_WT_SCHDL_TPRFL_RSRVN,
DB2INSTB.ODS_AEE_BOOK Alias_ODS_AEE_BOOK_WT_DEAL,
DB2INSTB.ODS_WT_SCHDL_DEAL_CPRTY ODS_WT_SCHDL_DEAL_CPRTY,
DB2INSTB.ODS_WT_SCHDL_DEAL_LPRFL ODS_WT_SCHDL_DEAL_LPRFL,
DB2INSTB.ODS_WT_SCHDL_DEAL_TPRFL ODS_WT_SCHDL_DEAL_TPRFL
WHERE
( ODS_WT_SCHDL_DEAL.PHYS_DEAL_NR=ODS_WT_SCHDL_DEAL_C PRTY.PHYS_DEAL_NR )
AND ( ODS_WT_SCHDL_DEAL_CPRTY.DEAL_NR=ODS_WT_DEAL.DEAL_N R )
AND ( ODS_STLMT_CNTR_PRTY_XREF.SOURCE_CPRTY_CD=ODS_WT_DE AL.CPRTY_NM
AND ODS_STLMT_CNTR_PRTY_XREF.SOURCE_SYS_CD = 'WT' )
AND
( ODS_WT_SCHDL_DEAL_LPRFL.PHYS_DEAL_NR=ODS_WT_SCHDL_ DEAL.PHYS_DEAL_NR )
AND
( ODS_WT_SCHDL_DEAL_LPRFL.PHYS_DEAL_NR=ODS_WT_SCHDL_ LPRFL_BLK.PHYS_DEAL_NR
and
ODS_WT_SCHDL_DEAL_LPRFL.LPRFL_ID=ODS_WT_SCHDL_LPRF L_BLK.LPRFL_ID )
AND
( ODS_WT_SCHDL_DEAL_LPRFL.PHYS_DEAL_NR=ODS_WT_SCHDL_ DEAL_TPRFL.PHYS_DEAL_NR )
AND
( ODS_WT_SCHDL_DEAL_LPRFL.TRNMT_PRVDR_NM=ODS_WT_SCHD L_DEAL_TPRFL.TRNMT_PRVDR_NM )
AND
( ODS_WT_SCHDL_DEAL_TPRFL.PHYS_DEAL_NR=ODS_WT_SCHDL_ TPRFL_RSRVN.PHYS_DEAL_NR )
AND
( ODS_WT_SCHDL_DEAL_TPRFL.SCHDL_DEAL_PRFL_ID=ODS_WT_ SCHDL_TPRFL_RSRVN.SCHDL_DEAL_PRFL_ID )
AND
( ODS_WT_SCHDL_DEAL_TPRFL.TRANS_PRFL_ID=ODS_WT_SCHDL _TPRFL_RSRVN.TRANS_PRFL_ID )
AND ( RTRIM(CHAR(RIGHT(ODS_WT_DEAL.BOOK_NM,
4)))=Alias_ODS_AEE_BOOK_WT_DEAL.BOOK_NAME )
AND
( Alias_ODS_AEE_BOOK_WT_DEAL.BOOK_ID=Alias_ODS_AEE_B OOK_DESIG_WT_DEAL.BOOK_ID )
AND (
( ( ODS_STLMT_CNTR_PRTY_XREF.CPRTY_CD ) NOT IN
('AEP','AEPGEN','AEPLOAD','AEPTCC','AEPTNC','PJM
OPRES','ERCOT','QFOXYCHEM','',' ') AND
( ODS_STLMT_CNTR_PRTY_XREF.CPRTY_CD ) NOT IN '%' )
AND ( ( ODS_WT_SCHDL_LPRFL_BLK.CPT_PERIOD_DT ) between '03/01/2007'
and '03/31/2007' AND (ODS_WT_SCHDL_LPRFL_BLK.CPT_PERIOD_DT >=
Alias_ODS_AEE_BOOK_DESIG_WT_DEAL.START_DATE AND
ODS_WT_SCHDL_LPRFL_BLK.CPT_PERIOD_DT <=
Alias_ODS_AEE_BOOK_DESIG_WT_DEAL.STOP_DATE) and
ODS_WT_SCHDL_LPRFL_BLK.HOUR_ENDING_DT >= date('03/01/2007') -1 day
and ODS_WT_SCHDL_LPRFL_BLK.HOUR_ENDING_DT<= date('03/31/2007') + 1
day
and ( Alias_EDW_PERIOD_WT_LPrfl.CPT_PERIOD_DT ) BETWEEN
ODS_STLMT_CNTR_PRTY_XREF.SOURCE_START_DT AND
ODS_STLMT_CNTR_PRTY_XREF.SOURCE_END_DT )
AND ODS_WT_SCHDL_DEAL.STAT_CD < 'VOIDED'
AND CASE WHEN
Alias_ODS_AEE_BOOK_DESIG_WT_DEAL.BOOK_DESIGNATION_ NAME = 'PW'
AND ( ODS_WT_SCHDL_DEAL.SRC_CD ) IN ('CSWS','PJM') THEN 'WT-On - PW'
WHEN Alias_ODS_AEE_BOOK_DESIG_WT_DEAL.BOOK_DESIGNATION_ NAME = 'PE'
AND ( ODS_WT_SCHDL_DEAL.SRC_CD ) IN ('CSWS','PJM') THEN 'WT-On - PE'
END IN ('WT-On - PE', 'WT-On - PW')
AND ODS_WT_DEAL.DEAL_TYP_TX < 'Transmission'
AND ODS_WT_DEAL.STATUS_CD < 'VOIDED'
AND ODS_WT_SCHDL_TPRFL_RSRVN.OWNER_NM IN ('AEPMEA', 'CSWMEO')
)
GROUP BY
RTRIM(CHAR(RIGHT(ODS_WT_DEAL.BOOK_NM,4))),
CASE WHEN Alias_ODS_AEE_BOOK_DESIG_WT_DEAL.BOOK_DESIGNATION_ NAME =
'PW'
AND ( ODS_WT_SCHDL_DEAL.SRC_CD ) IN ('CSWS','PJM') THEN 'WT-On - PW'
WHEN Alias_ODS_AEE_BOOK_DESIG_WT_DEAL.BOOK_DESIGNATION_ NAME = 'PE'
AND ( ODS_WT_SCHDL_DEAL.SRC_CD ) IN ('CSWS','PJM') THEN 'WT-On - PE'
END,
ODS_WT_SCHDL_DEAL.PHYS_DEAL_NR,
ODS_WT_SCHDL_LPRFL_BLK.CPT_PERIOD_DT,
ODS_WT_DEAL.TRAN_TYP_CD,
ODS_STLMT_CNTR_PRTY_XREF.CPRTY_CD,
ODS_WT_DEAL.DEAL_ID,
CHAR(ODS_WT_DEAL.DEAL_NR),
ODS_WT_DEAL.TRD_DT,
rtrim(ltrim(ODS_WT_DEAL.MKT1_NM)),
ODS_WT_DEAL.DEAL_TYP_TX,
RTRIM(ODS_WT_DEAL.TERM_TX),
ODS_WT_SCHDL_LPRFL_BLK.CPT_PERIOD_TS
)
);
Phil,
Thanks for the reply.
I have changed the optimization level of the database using
update db cfg using dft_queryopt 3
This was the best level that it had performed at.
Since this is coming from a Business Objects Universe. It is really
hard to do what you said with a temporary table.
I have experimented with MDC's to see if I can fix the access path
with them. I also tried Views. Because these influence the optimizer
also.
Thanks again for the reply.
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Joachim Klassen |
last post by:
Hi all,
first apologies if this question looks the same as another one I recently
posted - its a different thing but for the same szenario:-).
We are having performance problems when...
|
by: sherkozmo |
last post by:
SQL2000 - AccessXP
I built an adp file with a stored procedure from SQL as follows:
SELECT * FROM
Z_mis_sjk_job_code_access
WHERE job_code=@JobCode
UNION ALL
SELECT * FROM...
|
by: Salad |
last post by:
Every now and then I see ads that state something like "Experience with
Large Databases ...multi-gig...blah-de-blah" And I have to laugh.
What's the difference between a large or small database? ...
|
by: Peter Hickman |
last post by:
I have a program that requires x strings all of y length. x will be in the range
of 100-10000 whereas the strings will all be < 200 each.
This does not need to be grown once it has been created....
|
by: ranjeet.gupta |
last post by:
Dear ALL
As we know that when we declare the union then we have the size of the
union which is the size of the highest data type as in the below case
the
size should be 4 (For my case and...
|
by: Ken Allen |
last post by:
I have some code from C/C++ that I am attempting to port to C#. I have come
across an interesting problem that is quite common in complex C/C++ code:
the us of UNION in structure definitions to...
|
by: PaulR |
last post by:
Hi,
(re: DB2 LUW v8.1 fp8 optimisation Level2)
Can anyone explain why the following difference have wildly different
plans - this seems very fundamental)
select p.part_number,...
|
by: Yevgen Muntyan |
last post by:
Hey,
Why is it legal to do
union U {unsigned char u; int a;};
union U u;
u.a = 1;
u.u;
I tried to find it in the standard, but I only found that
|
by: wugon.net |
last post by:
question: db2 LUW V8 UNION ALL with table function month() have bad
query performance
Env:
db2 LUW V8 + FP14
Problem :
We have history data from 2005/01/01 ~ 2007/05/xx in single big...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
| |
