SET SIZE

SET SIZE

Welcome to our Knowledge Base

Documentation | Blog | Demos | Support

< All Topics
Print

SET SIZE

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

SET SELECTIVITY

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
How can we improve this article?
Please submit the reason for your vote so that we can improve the article.

Deixe um comentário

O seu endereço de e-mail não será publicado. Campos obrigatórios são marcados com *

pt_BRPortuguese