BEGIN
ctx_ddl.create_preference('mywordlist', 'BASIC_WORDLIST');
ctx_ddl.set_attribute('mywordlist', 'PREFIX_INDEX', 'TRUE');
ctx_ddl.set_attribute('mywordlist', 'PREFIX_MIN_LENGTH', '1');
ctx_ddl.set_attribute('mywordlist', 'SUBSTRING_INDEX', 'TRUE');
END;
/
CREATE INDEX LOCAL_SURNAME_CTX ON PUBAUTHOR(SURNAME) INDEXTYPE IS CTXSYS.CONTEXT PARAMETERS('Wordlist mywordlist');
CREATE INDEX LOCAL_SUFFIX_CTX ON PUBAUTHOR(SUFFIX) INDEXTYPE IS CTXSYS.CONTEXT PARAMETERS('Wordlist mywordlist');
CREATE INDEX LOCAL_GIVENNAMES_CTX ON PUBAUTHOR(GIVENNAMES) INDEXTYPE IS CTXSYS.CONTEXT PARAMETERS('Wordlist mywordlist');
CREATE INDEX LOCAL_PUBVALUES_CTX ON PUBPROP(VALUE) INDEXTYPE IS CTXSYS.CONTEXT PARAMETERS('Wordlist mywordlist');
CREATE INDEX LOCAL_PUBTITLE_CTX ON PUB(TITLE) INDEXTYPE IS CTXSYS.CONTEXT PARAMETERS('Wordlist mywordlist');
CREATE INDEX LOCAL_PUBSERIES_CTX ON PUB(SERIES_NAME) INDEXTYPE IS CTXSYS.CONTEXT PARAMETERS('Wordlist mywordlist');
CREATE INDEX LOCAL_SURNAME_IDX ON PUBAUTHOR(UPPER(SURNAME));
CREATE INDEX LOCAL_SUFFIX_IDX ON PUBAUTHOR(UPPER(SUFFIX));
CREATE INDEX LOCAL_GIVENNAMES_IDX ON PUBAUTHOR(UPPER(GIVENNAMES));
CREATE INDEX LOCAL_PUBSERIES_IDX ON PUB(UPPER(SERIES_NAME));