Single query vs multiple queries to fetch large number of rows in SAP HANA

Single query would always be better than the multiple queries. The number of rows does not impact much on performance. It is the way query is written and the data to be fetched which makes the difference. Also, the table should be indexed.

Smita Kapse

Updated on: 30-Jul-2019

1K+ Views

Kickstart Your Career

Get certified by completing the course

Get Started