Sets the estimated number of records in an EntitySet, relationship, application document, or result set.
SET SIZE object size
SET object SIZE size
|object||The name of an EntitySet, a relationship with fields, a structured application document, or a result set.|
|size||A positive number representing the estimated number of records in object.
A size of 0 instructs the software to use an internal default value for the size of object.
The SET SIZE command supplies the strategy analyzer with your estimate of the number of records in object. SET SIZE has no effect on the AvgSize field associated with object in the Object Dictionary.
The SET SIZE command is not affected by the SET RESET and SET RESTORE commands.
To set the estimated number of records in the EntitySet Employees to 5000, use
set size Employees 5000