SUPPRESS_SELECT_COUNT¶

Applies to: ORAFlex SQLFlex MYSQLFlex PGFlex DB2Flex

This command sets the value of DF_FILE_RECORDS_USED to a fixed value of zero. That way anytime a SELECT COUNT(*) is done, zero is returned, cutting down on server traffic. This is the same as setting SET_FIXED_FILE_RECORDS_USED to 0.

Syntax

SUPPRESS_SELECT_COUNT