[QODBC-Desktop] Troubleshooting - How do I get Table Record Count fastest way using QODBC
Posted by Jack - QODBC Support on 30 March 2016 10:33 AM
Troubleshooting - How do I get Table Record Count the fastest way using QODBC
What is the fastest way to get the number of records from a table?
QODBC would need to scan the whole table to get the record or row count. So you shouldn't do it if you don't need to. If you must do it, run the query against the optimized table using nosync like this: