• Home
• org.wikibrainapi
• wikibrain-core
• 0.7.2
• source code
• wikidata-create-indexes.sql

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

db.wikidata-create-indexes.sql Maven / Gradle / Ivy

CREATE INDEX IF NOT EXISTS WD_LABELS_IDX ON WIKIDATA_ENTITY_LABELS(ENTITY_TYPE, ENTITY_ID);
CREATE INDEX IF NOT EXISTS WD_DESC_IDX ON WIKIDATA_ENTITY_DESCRIPTIONS(ENTITY_TYPE, ENTITY_ID);
CREATE INDEX IF NOT EXISTS WD_ALIAS_IDX ON WIKIDATA_ENTITY_ALIASES(ENTITY_TYPE, ENTITY_ID);
CREATE INDEX IF NOT EXISTS WD_STATEMENT_ENTITY_IDX ON WIKIDATA_STATEMENT(ENTITY_TYPE, ENTITY_ID);
CREATE INDEX IF NOT EXISTS WD_STATEMENT_PROP_IDX ON WIKIDATA_STATEMENT(PROP_ID);
CREATE INDEX IF NOT EXISTS WD_STATEMENT_VAL_IDX ON WIKIDATA_STATEMENT(VAL_STR)