Skip to Content

HANA Studio SQL result limitation

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Apr 27 at 04:04 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded