Field BWSel

Field BWSel

Welcome to our Knowledge Base

Documentation | Blog | Demos | Support

< All Topics
Print

Field BWSel

Index selectivity factors. Index selectivity factors used by Zim’s strategy optimizer.

Valid Values

A number from 0 to 1.000 (DEFAULT = 1.000)

Remarks

The index selectivity factors are relevant for indexed fields only.

Each number represents the fraction of records that you would typically expect to retrieve using an indexed lookup with a particular operator or operators.

BWSel

selectivity factor for BETWEEN

EQSel

selectivity factor for the equals (=) operator

LGSel

selectivity factor for all other operators (i.e., less than (<), greater than (>), less than or equals (<=), greater than or equals (>=))

Values closer to 0 imply a very selective index, while values closer to 1 imply an index with poor selectivity. A value of 1.000 instructs Zim to use its internal selectivity factors.

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.

Leave a Reply

Your email address will not be published. Required fields are marked *

en_CAEnglish