Hi All,
I am fetching records from many voluminous tables having multiple joins based on filter criteria filled from frond end application. As per the selected criteria, I want to have a pre-check if query would return more than 1000 rows then I have to show user a message saying that he should refine the search.
Is there any performant way to query db and dynamically find record count and stops executions if it is going return more than the specified no of rows.
Thanks