Product Documentation

SQL Operations Guide

Previous Topic

Next Topic

SQL_MIN_CARD

SQL_MIN_CARD <# of rows>

Forces the SQL optimizer to consider that the tables contain, at minimum, <# of rows>.

Setting this value to any number greater than 0 (let say X) forces the optimizer to think that any table with less than X records contain X records. This may potentially help the optimizer, in certain cases, to chose the proper execution plan for tables even if the tables are actually empty.

Default: 0

TOCIndex