Skip to Content
0

Updating System Limitations

Feb 10, 2017 at 01:46 AM

106

avatar image
Former Member

M_SYSTEM_LIMITS view provides the system capabilities. For example

MAXIMUM_NUMBER_OF_JOIN_TABLES_IN_STATEMENT

, this setting is for Number of joined tables in an SQL statement or view and the default is 255.

Is there any way to change this default value? I tried adding this parameter in configuration section for Index server --> sql section but it does not work.

I am trying to limit the number of tables that can be used in any join across the hana system.

Any advice is appreciated.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Lars Breddemann
Feb 12, 2017 at 09:20 AM
0

The view provides information on limitations of the installed HANA software. These limits cannot be changed by parameters.

Out of interest: what kind of data model requires more than 255 joins in a single statement? Is that a EAV/OTLT/MUCK design (http://www.databaseanswers.org/data_models/entity_attribute_values/facts.htm) ?

Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Thank you Lars. I am not trying to increase the joins and trying to limit it. I created a calculation view that joins around 30 tables and 800 columns for the UI/Lumira to build query dynamically. My intend is for UI/Lumira to limit the number of columns/tables they use in a single query using this calculation view. For any reason if they use all 800 columns and fire a query/create a table chart in lumira, it will bring down the system. Instead I want to limit this to for example at max of 50 columns and 10 tables in any query that runs on the application.

Pl. advice

0