Currently, values of properties are stored in table PROPERTIES exclusively in a CLOB.
While this allows to support properties which value is bigger than 4000 chars, this is not efficient when retrieving the information where only very rare properties exceed this limit.
We should rather use a CLOB only when needed and by default store the value of properties in a VARCHAR column.
- add column PROPERTIES.TEXT_VALUE_OVERFLOW of type CLOB (nullable)
- this column should be populated with the value of PROPERTIES.TEXT_VALUE when it's size is > 4000. In this case, PROPERTIES.TEXT_VALUE should set to null
- change type of column PROPERTIES.TEXT_VALUE from CLOB to VARCHAR and keep it nullable