Skip to content

Feature/suffix index

Pavel Mashliakovskiy requested to merge feature/suffixIndex into ver/5.18.x

a new dbExtensions type - SUFFIXES index Creates index organized table. Fills it by all possible suffixes of attribute value using splitChars as separator. Select queries with like condition on such attributes will use 'exists' in this table where tail line %? instead of 'like %?%' on the main table what prevents a full scan.

A usage sample:

 "dbExtensions": {
   "TST_DOCUMENT_CODE_SU": {
     "type": "SUFFIXES",
     "description": "Creates index organized table TST_DOCUMENT_CODE_SU(TAIL, ID)",
     "splitChars": "/-",
     "includeLast": false,
     "attribute": "code"
   }
 }
Edited by Pavel Mashliakovskiy

Merge request reports