Database indexes

SHOW INDEX FROM <tablename>

biblioref_reference

CREATE INDEX idx_biblioref_reference_cooperative_center_code on biblioref_reference(cooperative_center_code);

CREATE INDEX idx_biblioref_reference_literature_type_treatment_level on biblioref_reference(literature_type,treatment_level);

CREATE INDEX idx_biblioref_reference_status on biblioref_reference(status);

CREATE INDEX idx_biblioref_updated_time on biblioref_reference(updated_time);

CREATE INDEX idx_biblioref_reference_reference_title on biblioref_reference(reference_title(60));

CREATE INDEX idx_lilacs_original_id on biblioref_reference(LILACS_original_id);

CREATE INDEX idx_publication_date on biblioref_reference(publication_date_normalized);

biblioref_referencesource

CREATE INDEX idx_volume_issue on biblioref_referencesource(volume_serial, issue_number);

CREATE INDEX idx_biblioref_referencesource_id on biblioref_referencesource(reference_ptr_id);

CREATE INDEX idx_biblioref_referencesource_title_serial on biblioref_referencesource(title_serial(60));

biblioref_referenceanalytic

CREATE INDEX idx_biblioref_referenceanalytic_id on biblioref_referenceanalytic(reference_ptr_id);

CREATE INDEX idx_biblioref_referenceanalytic_source_id on biblioref_referenceanalytic(source_id);

title_title

CREATE INDEX idx_title_title_title on title_title(title)

CREATE INDEX idx_title_title_shortened_title on title_title(shortened_title)

CREATE INDEX idx_title_title_issn on title_title(issn)

CREATE INDEX idx_title_indexrange_ids on title_indexrange(title_id, index_code_id)

CREATE INDEX idx_title_titlevariance_other_title on title_titlevariance(title_id, type, issn)

main_descriptor

CREATE INDEX idx_main_descriptor_object_content_type_id on main_descriptor(object_id,content_type_id);

django_admin_log

CREATE INDEX idx_django_admin_log_action_flag_object_id on django_admin_log(action_flag, object_id)

institution_institution

CREATE INDEX idx_institution_name on institution_institution(name);

CREATE INDEX idx_institution_acronym on institution_institution(acronym);

CREATE INDEX idx_institution_unit_name on institution_unit(name);

CREATE INDEX idx_institution_unit_acronym on institution_unit(acronym);

thesaurus descriptors

CREATE INDEX idx_thesaurus_treenumberslistdesc_tree_number on thesaurus_treenumberslistdesc(tree_number);

CREATE INDEX idx_thesaurus_identifierconceptlistdesc_preferred_concept on thesaurus_identifierconceptlistdesc(preferred_concept);

CREATE INDEX idx_thesaurus_termlistdesc_three_fields on thesaurus_termlistdesc(term_thesaurus,concept_preferred_term,record_preferred_term);

thesaurus qualifiers

CREATE INDEX idx_thesaurus_treenumberslistqualif_tree_number on thesaurus_treenumberslistqualif(tree_number);

CREATE INDEX idx_thesaurus_identifierconceptlistqualif_preferred_concept on thesaurus_identifierconceptlistqualif(preferred_concept);

CREATE INDEX idx_thesaurus_termlistqualif_four_fields on thesaurus_termlistqualif(term_thesaurus,concept_preferred_term,record_preferred_term,entry_version);

FULLTEXT INDEX

ALTER TABLE main_resource ADD FULLTEXT(title, link);

ALTER TABLE biblioref_reference ADD FULLTEXT(reference_title);

ALTER TABLE institution_institution ADD FULLTEXT(name, acronym);

ALTER TABLE institution_unit ADD FULLTEXT(name, acronym);

CONFIG FOR FULLTEXT

Adicionar no arquivo /etc/my.cnf a seguinte linha para configurar o mínimo de caracteres para a busca (default = 4)

ft_min_word_len = 3

• Necessário reiniciar o MySQL

APAGAR INDICE

DROP INDEX idx_biblioref_reference_reference_title ON biblioref_reference;