Always Prefer Modeling Views over SQLScript Procedure:
Modeling views (Attribute view, Analytic view and Calculation view) are specially designed artifacts for HANA. As a developer you do not need to worry about query optimization and parallelization.
These modeling views are faster than SQLScript procedures almost in all the scenarios. Plus these views are easier for others to understand, remodel and change.
However, there are some complex scenarios which cannot be implemented in modeling views and you need SQLScript procedures for that. But if you do not write it carefully you might end up with inefficient code.
SQLScript should always be second option compare to modeling views.
Click here to go to Next Chapter. 6.2 Performance Guidelines - General Principles
Modeling views (Attribute view, Analytic view and Calculation view) are specially designed artifacts for HANA. As a developer you do not need to worry about query optimization and parallelization.
These modeling views are faster than SQLScript procedures almost in all the scenarios. Plus these views are easier for others to understand, remodel and change.
However, there are some complex scenarios which cannot be implemented in modeling views and you need SQLScript procedures for that. But if you do not write it carefully you might end up with inefficient code.
SQLScript should always be second option compare to modeling views.
Click here to go to Next Chapter. 6.2 Performance Guidelines - General Principles
No comments:
Post a Comment