Skip to Content
0

HANA Studio SQL result limitation

Apr 27 at 03:49 AM

36

avatar image
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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Lars Breddemann
Apr 27 at 04:04 AM
1

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.

Share
10 |10000 characters needed characters left characters exceeded