FORECASTING QUERIES IN ORACLE
Francisco Javier Moreno, Anderson Franco García, Jaime Echeverri · 2008
In order to make analyisis and what if queries, Oracle has included to SQL language the MODEL clause. This type of queries can be posed in SQL standard too. In this article we compare both approaches. We present a set of queries through MODEL clause and SQL standard. The results evidence the advantages of the MODEL clause: the simplicity in the queries implementation and the computational saving that is reached avoiding joins, correlated subqueries and unions.