All Discussions Tagged 'GotoDate' - OracleConnections2024-03-29T11:53:51Zhttp://www.oracleconnections.com/forum/topic/listForTag?groupUrl=oracle-business-intelligence&tag=GotoDate&feed=yes&xn_auth=noPerformance problem with GotoDatetag:www.oracleconnections.com,2013-07-05:6612035:Topic:220802013-07-05T10:05:46.376ZBarn Mitchelhttp://www.oracleconnections.com/profile/BarnMitchel
<p>hi everyone!</p>
<p>we're facing a performance issue when looking at historical data based on GotoDate().<br></br> The following points apply to our case:<br></br> - the problem only appears for one specific table, it's not a global problem (at least we currently only found this table to cause problems)<br></br> - the problem only appears when using GotoDate(). When using GotoSavepoint(), performance is as expected.<br></br> - Explain plan is the same for both Savepoints and GotoDate() (which is probably as…</p>
<p>hi everyone!</p>
<p>we're facing a performance issue when looking at historical data based on GotoDate().<br/> The following points apply to our case:<br/> - the problem only appears for one specific table, it's not a global problem (at least we currently only found this table to cause problems)<br/> - the problem only appears when using GotoDate(). When using GotoSavepoint(), performance is as expected.<br/> - Explain plan is the same for both Savepoints and GotoDate() (which is probably as expected, as only the session context changes?)</p>
<p>While a select takes < 0.1s when working on LATEST or any Savepoint it takes something between 30s and 150s when working on a date.<br/> Any hints what could cause that problem? The table contains base data, thus it changes rarely.<br/> Unfortunately the data in there is quite important and connected to several other tables and processes within our application. So for our customer analyzing historical data is currently extremely slow.</p>
<p>kind regards,</p>