EFEUThe Perfect Tool for Data Warehousing

EFEU ”The Perfect Tool for Data Warehousing

In the past sections, you explored multidimensional data structures and multidimensional results extensively.

You learned that basically all operations can be done by using plain SQL code. The problem with SQL is that some operations can hardly be performed, or the desired result can be obtained only at the cost of a significant performance decrease. The more complex an operation is, the more performance you can lose, because the execution plan of a query becomes terribly complicated and the optimizer can hardly find the best way through it.

This is only a preview

This is only a preview of the full book. From here, you may:

• Login.
• Try it FREE for 14 days.
• Subscribe.
• You can continue your free preview of this book or return to search results.