disable hint first_rows

Description

By default, Uniface generates the optimizer hint first_rows for appropriate situations. The generated hint is also included in the SQL statements in the stored packages. Using hints in certain situations can have a negative impact on performance.

If the disable hint first_rows option is set, Uniface does not include the hint in the stored packages, whether these are created o nthe fly or by scripts generated by the Create Table facility.

If you want to include the hint in some packages but not in others, you can set the disable hint first_rows option in the assignment file, and then run the Create Table facility (/genSqlcreatetable) for individual tables.