HANA Table Variable access vs Column Table access SQLScript

[sap_cohort]

I have 2 "similar" SQL Selections that pull data from a Column Table. Some of the selections are the same. Between the 2 sql selects, 3 of the "where" clauses are the same and both have another one that is different.

1. Would it be better to create a single SQL using the similar where clauses and then select out the different data from Table Variable?

2. The big question I have Is:
Is there any difference in performance when selecting from a column table vs a Variable Table? I can't seem to find any information on this online.

Thanks!

[sap_cohort]

Hi and thanks for the response. I was thinking of a simpler issue. I was wondering if access to a HANA Table with 1 key would have the same performance as accessing a table variable of the same definition. Thanks for the input.