Contents Index RI_TRIGGER_TIME option [compatibility] SCALE option [database]

ASA Database Administration Guide
  Database Options
    Alphabetical list of options

ROW_COUNTS option [database]


Function 

Specifies whether the database will always count the number of rows in a query when it is opened.

Allowed values 

ON, OFF

Scope 

Can be set for an individual connection or for the PUBLIC group. Takes effect immediately.

Default 

OFF

Description 

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.

Warning: When ROW_COUNTS is set to ON, it may take significantly longer to execute queries. In fact, it will usually cause Adaptive Server Anywhere to execute the query twice, doubling the execution time.


Contents Index RI_TRIGGER_TIME option [compatibility] SCALE option [database]