More information about the
<SQL> query being executed, set at
every iteration and at the end of the loop.
the minimum and maximum number of total (i.e. ignoring
MAX) result rows that will be returned. In
cases where the exact number of result rows is not yet known (e.g.
post-processing is required), the two will differ. If the upper or
lower limit is not known (e.g. a completely unindexed query), one or
both variables will be negative. If both variables are equal, the
total row count is exact.
similar, but are the min/max total rows matched - i.e. by the
WHERE clause, before any reduction by likeprows, GROUP BY etc.
$sqlresult.indexcount is the same as
is set to -1 (not 0) when unknown, to distinguish from 0 (known but zero
$sqlresult.$...$ variables were added in version 6. They
are more accurate than the
$rows.$...$ variables, as their
information is obtained directly from the Texis SQL engine. See
here for more on these variables.