SET SIZE
Welcome to our Knowledge Base
Documentation | Blog | Demos | Support
< All Topics
Print
SET SIZE
0 out of 5 stars
| 5 Stars | 0% | |
| 4 Stars | 0% | |
| 3 Stars | 0% | |
| 2 Stars | 0% | |
| 1 Stars | 0% |
Sets the estimated number of records in an EntitySet, relationship, application document, or result set.
Syntax #1
SET SIZE object size
or
SET object SIZE size
Parameters
| 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. |
Comments
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.
Example
To set the estimated number of records in the EntitySet Employees to 5000, use
set size Employees 5000
See Also
Updated
ByJason Lee
Was this article helpful?
0 out of 5 stars
| 5 Stars | 0% | |
| 4 Stars | 0% | |
| 3 Stars | 0% | |
| 2 Stars | 0% | |
| 1 Stars | 0% |
5
Portuguese 
English