- Trending Categories
Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Physics
Chemistry
Biology
Mathematics
English
Economics
Psychology
Social Studies
Fashion Studies
Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
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.
- Related Articles
- Update multiple rows in a single MongoDB query?
- Insert multiple rows in a single MySQL query
- Use LIKE % to fetch multiple values in a single MySQL query
- How to get multiple rows in a single MySQL query?
- How to obtain multiple rows in a single MySQL query?
- How to insert multiple rows with single MySQL query?
- Replacing multiple occurrence by a single occurrence in SAP HANA
- Running OLAP queries in SAP HANA
- Importing limited number of rows from CSV in SAP HANA
- Fetch the modified date of table in SAP HANA
- MySQL query to fetch multiple least values?
- How will you extract multiple rows from a DB2 table in a single FETCH call?
- MySQL query to count rows in multiple tables
- Create table SQL query in SAP HANA
- Running an OLTP query in SAP HANA
Advertisements