Switch to: V9V8V7V6V5

Valentina Database Index Styles

Description

Valentina 2.0 introduce brand-new feature - Index Style.

Working with indexes may happens that you will need settings A for some set of fields, and settings B for another set of fields. To simplify work with such task Valentina Kernel offers Index Styles. You define some style, then apply it to many indexes exactly as we do with text in most editors.

Index style specifies information how to index values. In Valentina 2.0 index style can be used for a String, VarChar or Text field.

Database can have several index styles. Index style should be defined before you will use it. Each index style should have an unique name.

To use an index style you assign to a field one of existed index styles by name. If you change index style of a field then index of the field will be rebuilt automatically.

NOTE: Index Style cannot be changed after definition (at least in 2.0).

String Index Style

This type of index style can specify the following parameters:

IgnoreLength

All strings that have length equal to or less of IgnoreLength will not be included into index.

This allows you easy exclude from indexing such often words as “a“, “or“, “and“, “the“, … As result you will get smaller index.

IgnoreWords

List of words which should not be included into index. You specify this list as string that contains words separated by space.