
9.2
Types of Analysis Reporting 251
Chapter 9
more comprehensive and granular data warehouse data is, the more accu-
rate predictive analytical reporting will be. The downside to this is that the
larger the data warehouse becomes, the longer reporting will take to pro-
duce results, and the more development and maintenance person-hours
are required.
9.1.1 How Does Analysis Reporting
Affect Performance?
In general, Oracle SQL includes a slew of functionality and specialized SQL
expressions and syntax that can be used to make analytical queries much
simpler. Provided functionality is built into, and executed within, the
Oracle Database query engine in ...