When we open a Fox table, we instantly know the total records in the table.

When I open a SQL remote view it can take several minutes to know how many records there are.

How can I determine the number of records in an SQL remote view without waiting for the entire file to load?