Datamanager table listing: get total record count + records in single query
When fetching records for the datatable in datamanager, we fire off two queries:
1. To fetch the total number of records
2. To fetch the paginated recordset
The performance of this could be improved by using using Count Over Window Function to fetch the total rows as a column in the single query to get the paginated recordset. This will especially improve performance for large tables and when complex filters are applied.