Maximum number of joins

[former_member184624]

Dear HANA Experts,

Currently i am creating the table function and i am trying to join many tables (1 Inner and 65 left outer joins). Please let me know, what is the maximum limit of joining the tables. I am using With table expression and records are less in all tables. Please suggest.

Thanks.

[Cocquerel · Accepted solution]

There is a default limit of 4095 joined tables but it can be extended via parameter (see details in the following note 2154870 - How-To: Understanding and defining SAP HANA Limitations )