Kamus Skema Tabel Database

CREATE INDEX CONCURRENTLY idx_model_filed_textField_xxxxx ON odin_open_application_data (
        namespace_code,
        table_name,
        is_deleted,
        parent_pid,
        (json_data ->> 'textField_xxxxx')
    ) WHERE namespace_code = 'APP_xxxx' and table_name = 'xxxx';

select count(*) from yida_app_data_form_xxxxx a WHERE ( a.is_deleted = 'n' AND ( a.phy_textfield_lmsj0bkf = 'xxx')) AND ( a.namespace_code = 'xxxx' AND  a.table_name = 'xxx' AND  a.parent_pid IS NULL)

Buat indeks btree pada phy_textfield_lmsj0bkf

CREATE INDEX CONCURRENTLY idx_model_phy_textfield_lmsj0bkf ON yida_app_data_form_xxxxx (
        namespace_code,
        table_name,
        is_deleted,
        parent_pid,
        phy_textfield_lmsj0bkf
)

String physicalTableName = tableName.substring(0, 63 - tableNameHashPostfix.length()) + tableNameHashPostfix;