Query one Lakh record

FYI a lot of readers here might not be familiar with the term "Lakh", referring to a hundred thousand (100,000) of something.  I saw it mentioned previously a few years ago and I had to look it up at that time.

As for querying that much data -- we need more information to really give you meaningful / useful answers.  What is the nature and depth of that data?  What do you intend to do with it after it's been queried?  In general, I've found in the past that the best way to deal with bulky data like this is to create a process that steps through batches of data at a time, processing between 1,000 and 10,000 rows at once (depending on the size of a given row).  But that would vary per different use cases of course.

Working with any application (irrespective of Appian) if requirement is to query huge records from database below are few suggestions for same:

1. Make sure you have proper indexing on table. And while trying to make query use this indexes accordingly to make retrieval of data faster

2. In select query keep only those fields which needs to be displayed

3. Ask dba to check query execution plan, and make changes at db level to optimize the query plan