Not compromised by B-tree limitations. Create indexes based on calculated fields, or any SQL expression based on fields.
Indexing with Valentina DB
A database index is a data structure that improves the speed of data retrieval operations but usually at the cost of additional writes and storage space to maintain the index data structure.
Valentina DB Index Types
Valentina DB has native support of two database index types: Default and Hash. It also has compatibility support for Multicolumn indexes.
- Default
- A non B-tree, inverted text index system
- Hash
- A highly efficient method for indexing long string and binary fields
- Multicolumn
- Supported for better and easier porting to Valentina DB. Valentina ObjectPtr and BinaryLink are more faster and more efficient solutions
Table Methods as Index Type Replacements
Some database systems support indexes on expressions or partial indexes. Valentina DB Table Methods are an improvement on both.