Feature/suffix index
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