Mention the difference between the Variable and Input parameter in HANA?
Answer»
Variables are attached to COLUMNS and are employed for filtering with the help of WHERE clauses. They can just include the VALUES available in the Columns they associate to. Variables do not affect the performance,
HANA Input parameters are used to drive the execution on the basis of user input. Occasionally, you might not want a variable to simply limit the data of a view. But you might also want to take input from the customer and PROCESS it, returning dynamic data on the basis of the user selection. Input Parameters makes this achievable.