row_counts option

On, Off

Off

Can be set for an individual connection or for PUBLIC. You must have the SET ANY PUBLIC OPTION system privilege to set this option for PUBLIC or for another user or role. Takes effect immediately.

If this option is set to Off, the row count is usually only an estimate. If this option is set to On, the row count is always accurate.

Caution

When row_counts is set to On, it may take significantly longer to execute queries. In fact, it usually causes SQL Anywhere to execute the query twice, doubling the execution time.

C API: sqlany_num_rows method [SQL Anywhere C]
PHP API: sasql_num_rows
Propriété de connexion row_counts

row_counts option

Allowed values

Default

Scope

Remarks

Caution

See also