Skip to content

Database indexes

Vinicius de Andrade edited this page Apr 25, 2023 · 1 revision

thesaurus_firstlevel

CREATE INDEX idx_firstlevel_type on thesaurus_firstlevel(type);

CREATE INDEX idx_firstlevel_thesaurus on thesaurus_firstlevel(thesaurus);

CREATE INDEX idx_firstlevel_treeNumber on thesaurus_firstlevel(treeNumber);

thesaurus_treenumberslistdesc

CREATE INDEX idx_thesaurus_treenumberslistdesc_tree_number on thesaurus_treenumberslistdesc(tree_number);

Clone this wiki locally