Counting Rows

The Row Count feature is provided to aid in browsing large data sources. Clicking the Row Count icon CountQueryIcon.gif in the data type view tool bar runs a count query instead of querying for the actual row data. Most data sources can run count queries much faster than queries that return the row data. The Auto Query option should be deselected to make effective use of count queries. Otherwise the normal row data query ran automatically thereby negating much of the benefit from performing a count query. The count query result is displayed in an information window that opens when the count query execution completes.

CountQueryDialog.jpg