HANA Studio SQL result limitation

[Former Member]

What is the difference between including TOP statement in HANA sql v/s the restriction put by number in preference settings? Does it the automatically put TOP statement? Does it execute the query fully (without records restriction ) and then limit the result based on preference settings?

Thanks in advance.

[lbreddemann · Accepted solution]

The limitation in SAP HANA studio is about how many records will be fetched at most from any result set.

The SQL statement itself is not affected. An exception to this is the data preview functionality, where you will see TOP n clauses in the generated statements.