A requirement is like this:
2 tables - employee and condition. In condition table, there can be 0 or n number of records.
Based on condition table, data from employee has to be fetched depending on attribute operator and value.
An attribute may occur more than once also (example EID).
With dynamic SQL, it is easy to evaluate but it effects the performance as my table size is very huge.
How to achieve this efficiently?
Copying SAP HANA Developer Center