Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
Specifies whether the database always count the number of rows in a query when it is opened.
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
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.