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

SAP HANASAPSAP Basis

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.

raja
Updated on 30-Jul-2019 22:30:20

Advertisements