A follow up on the case of "Same SELECT used in an INSERT has different Execution Plan" The query has the following predicate :CH.CONTACTDATETIME > SYSDATE-5The...
A follow up on the case of "Same SELECT used in an INSERT has different Execution Plan" The query has the following predicate :CH.CONTACTDATETIME > SYSDATE-5The testcase I have has table,column,index statistics from 27-jun-2013.If I run *today* the insert with the SYSDATE clause on my testcase with stats from 27-jun-2013 then I get a very poor cardinality estimation on access to CH because the stats reflect data there is little or no data present from after 27-jun-2013. This...
A follow up on the case of "Same SELECT used in an INSERT has different Execution Plan" The query has the following predicate :CH.CONTACTDATETIME > SYSDATE-5The testcase I have has table,column,index...
A customer complained that a query and its INSERT counterpart had different execution plans, and of course, the INSERT was slower. First lets look at the SELECT...
A customer complained that a query and its INSERT counterpart had different execution plans, and of course, the INSERT was slower. First lets look at the SELECT : SELECT ua_tr_rundatetime, ua_ch_treatmentcode, ua_tr_treatmentcode, ua_ch_cellid, ua_tr_cellid FROM (SELECT DISTINCT CH.treatmentcode AS UA_CH_TREATMENTCODE, CH.cellid AS UA_CH_CELLID FROM CH, DL WHERE CH.contactdatetime...
A customer complained that a query and its INSERT counterpart had different execution plans, and of course, the INSERT was slower. First lets look at the SELECT : SELECT ua_tr_rundatetime, ...
When making changes to the RDBMS,the developers of Oracle are always wondering if the new change will introduce a regression. Every change is checked against a...
When making changes to the RDBMS,the developers of Oracle are always wondering if the new change will introduce a regression. Every change is checked against a suite of regressions tests to try to trap if the change introduced a regression and fix it before it is released to our clients. Just in case that change does introduce a regression the developers add parameters and events to disable them. These are the workarounds used when a defect is encounter. But sometimes the...
When making changes to the RDBMS,the developers of Oracle are always wondering if the new change will introduce a regression. Every change is checked against a suite of regressions tests to try to...
BugTags What are Bugtags ? The bug database keeps dialogue and fix information for suspected product defects for various Oracle products. Some bugs are true...
BugTags What are Bugtags ? The bug database keeps dialogue and fix information for suspected product defects for various Oracle products. Some bugs are true defects and get fixed in some code line, sometimes with detailed information about the defect and sometimes with very little comment. Some times they are enhancements to features or new features altogehter, also with or without details. A bugtag is a separate entity which can be created for any fixed defect or...
BugTags What are Bugtags ? The bug database keeps dialogue and fix information for suspected product defects for various Oracle products. Some bugs are true defects and get fixed in some code line,...