- Real Time Analytics with SAP HANA
- Vinay Singh
- 142字
- 2021-07-09 21:20:52
Unions versus JOINS
Unions are used to combine the result set of two or more SELECT statements. It's always tempting to JOIN two analytic views when measures from more than one table are required. This should, however, be avoided for performance reasons. It is more beneficial to use a Union in a calculation view. Technically, a Union is not a JOIN type.
Points to remember:
- Union is not supported in the attribute or analytical view but can only be used in calculation views.
- Union with constant values are supported within graphical calculation views and the Union operator can accept 1..N input sources.
- Script-based calculation views can only accept two input sources at a given time.
- Do not JOIN analytical views (to be discussed later), as you might have performance issues. Instead, use Union with constant values when working with multiple fact tables.
推薦閱讀
- Boost程序庫完全開發指南：深入C++”準”標準庫（第5版）
- 圖解Java數據結構與算法（微課視頻版）
- PLC編程及應用實戰
- Microsoft Dynamics GP 2013 Reporting, Second Edition
- Jupyter數據科學實戰
- Java Web程序設計任務教程
- Salesforce Reporting and Dashboards
- 編程菜鳥學Python數據分析
- Visual Foxpro 9.0數據庫程序設計教程
- 新一代SDN：VMware NSX 網絡原理與實踐
- Mastering Web Application Development with AngularJS
- Programming Microsoft Dynamics? NAV 2015
- Java高手是怎樣煉成的：原理、方法與實踐
- C/C++代碼調試的藝術（第2版）
- 例說FPGA：可直接用于工程項目的第一手經驗