Skip to Content
0
Apr 19, 2018 at 09:57 PM

HANA Table Variable access vs Column Table access SQLScript

543 Views

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!