Knowledgebase
[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 fastest way using QODBC

Problem Description:

What is the fastest way to get the number of records from a table? 

Solution:

QODBC would need to scan the whole table to get the record or row count. So you shouldn't do it if don't need to do it. If you must do it, run the query against the optimized table using nosync like this:

SELECT count(listid) as "Table Row Count" from Customer nosync


(0 vote(s))
Helpful
Not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please complete the captcha below (we use this to prevent automated submissions).