Unused Indexes on dolibarr database
List of indexes never used (idx_scan to 0)
Shema | Table | Index | Code |
---|---|---|---|
public | llx_accountingaccount | idx_accountingaccount_fk_pcg_version | CREATE INDEX idx_accountingaccount_fk_pcg_version ON llx_accountingaccount USING btree (fk_pcg_version) |
public | llx_actioncomm | idx_actioncomm_datea | CREATE INDEX idx_actioncomm_datea ON llx_actioncomm USING btree (datea) |
public | llx_actioncomm_extrafields | idx_actioncomm_extrafields | CREATE INDEX idx_actioncomm_extrafields ON llx_actioncomm_extrafields USING btree (fk_object) |
public | llx_adherent | idx_adherent_fk_adherent_type | CREATE INDEX idx_adherent_fk_adherent_type ON llx_adherent USING btree (fk_adherent_type) |
public | llx_adherent_extrafields | idx_adherent_options | CREATE INDEX idx_adherent_options ON llx_adherent_extrafields USING btree (fk_object) |
public | llx_adherent_type_extrafields | idx_adherent_type_extrafields | CREATE INDEX idx_adherent_type_extrafields ON llx_adherent_type_extrafields USING btree (fk_object) |
public | llx_agefodd_contact | idx_agefodd_contact_fk_socpeople | CREATE INDEX idx_agefodd_contact_fk_socpeople ON llx_agefodd_contact USING btree (fk_socpeople) |
public | llx_agefodd_convention | idx_fk_agefodd_session_conv | CREATE INDEX idx_fk_agefodd_session_conv ON llx_agefodd_convention USING btree (fk_agefodd_session) |
public | llx_agefodd_facture | idx_fk_societe_fac | CREATE INDEX idx_fk_societe_fac ON llx_agefodd_facture USING btree (fk_societe) |
public | llx_agefodd_formateur | idx_agefodd_formateur_fk_socpeople | CREATE INDEX idx_agefodd_formateur_fk_socpeople ON llx_agefodd_formateur USING btree (fk_socpeople) |
public | llx_agefodd_formateur | idx_agefodd_formateur_fk_user | CREATE INDEX idx_agefodd_formateur_fk_user ON llx_agefodd_formateur USING btree (fk_user) |
public | llx_agefodd_formation_catalogue_extrafields | idx_agefodd_formation_catalogue_extrafields | CREATE INDEX idx_agefodd_formation_catalogue_extrafields ON llx_agefodd_formation_catalogue_extrafields USING btree (fk_object) |
public | llx_agefodd_formation_objectifs_peda | fk_formation_catalogue_obj_peda | CREATE INDEX fk_formation_catalogue_obj_peda ON llx_agefodd_formation_objectifs_peda USING btree (fk_formation_catalogue) |
public | llx_agefodd_place | archive_place | CREATE INDEX archive_place ON llx_agefodd_place USING btree (archive) |
public | llx_agefodd_session_contact | fk_session_sess_contact | CREATE INDEX fk_session_sess_contact ON llx_agefodd_session_contact USING btree (fk_session_agefodd) |
public | llx_agefodd_session_extrafields | idx_agefodd_session_extrafields | CREATE INDEX idx_agefodd_session_extrafields ON llx_agefodd_session_extrafields USING btree (fk_object) |
public | llx_agefodd_session_formateur | idx_fk_agefodd_sess_formateur | CREATE INDEX idx_fk_agefodd_sess_formateur ON llx_agefodd_session_formateur USING btree (fk_agefodd_formateur) |
public | llx_agefodd_session_stagiaire | fk_agefodd_stagiaire_type_sess_sta | CREATE INDEX fk_agefodd_stagiaire_type_sess_sta ON llx_agefodd_session_stagiaire USING btree (fk_agefodd_stagiaire_type) |
public | llx_agefodd_stagiaire | nom_sta | CREATE INDEX nom_sta ON llx_agefodd_stagiaire USING btree (nom) |
public | llx_agefodd_training_admlevel | fk_agefodd_training_admlevel | CREATE INDEX fk_agefodd_training_admlevel ON llx_agefodd_training_admlevel USING btree (fk_training) |
public | llx_bank | idx_bank_datev | CREATE INDEX idx_bank_datev ON llx_bank USING btree (datev) |
public | llx_boxes | idx_boxes_boxid | CREATE INDEX idx_boxes_boxid ON llx_boxes USING btree (box_id) |
public | llx_boxes | idx_boxes_fk_user | CREATE INDEX idx_boxes_fk_user ON llx_boxes USING btree (fk_user) |
public | llx_c_action_trigger | idx_action_trigger_rang | CREATE INDEX idx_action_trigger_rang ON llx_c_action_trigger USING btree (rang) |
public | llx_c_ziptown | idx_c_ziptown_fk_county | CREATE INDEX idx_c_ziptown_fk_county ON llx_c_ziptown USING btree (fk_county) |
public | llx_categorie | idx_categorie_label | CREATE INDEX idx_categorie_label ON llx_categorie USING btree (label) |
public | llx_categorie | idx_categorie_type | CREATE INDEX idx_categorie_type ON llx_categorie USING btree (type) |
public | llx_categorie_fournisseur | idx_categorie_fournisseur_fk_categorie | CREATE INDEX idx_categorie_fournisseur_fk_categorie ON llx_categorie_fournisseur USING btree (fk_categorie) |
public | llx_categorie_fournisseur | idx_categorie_fournisseur_fk_societe | CREATE INDEX idx_categorie_fournisseur_fk_societe ON llx_categorie_fournisseur USING btree (fk_societe) |
public | llx_categorie_member | idx_categorie_member_fk_categorie | CREATE INDEX idx_categorie_member_fk_categorie ON llx_categorie_member USING btree (fk_categorie) |
public | llx_categorie_member | idx_categorie_member_fk_member | CREATE INDEX idx_categorie_member_fk_member ON llx_categorie_member USING btree (fk_member) |
public | llx_categorie_product | idx_categorie_product_fk_categorie | CREATE INDEX idx_categorie_product_fk_categorie ON llx_categorie_product USING btree (fk_categorie) |
public | llx_categorie_product | idx_categorie_product_fk_product | CREATE INDEX idx_categorie_product_fk_product ON llx_categorie_product USING btree (fk_product) |
public | llx_categorie_societe | idx_categorie_societe_fk_categorie | CREATE INDEX idx_categorie_societe_fk_categorie ON llx_categorie_societe USING btree (fk_categorie) |
public | llx_categorie_societe | idx_categorie_societe_fk_societe | CREATE INDEX idx_categorie_societe_fk_societe ON llx_categorie_societe USING btree (fk_societe) |
public | llx_commande | idx_commande_fk_account | CREATE INDEX idx_commande_fk_account ON llx_commande USING btree (fk_account) |
public | llx_commande | idx_commande_fk_currency | CREATE INDEX idx_commande_fk_currency ON llx_commande USING btree (fk_currency) |
public | llx_commande | idx_commande_fk_projet | CREATE INDEX idx_commande_fk_projet ON llx_commande USING btree (fk_projet) |
public | llx_commande | idx_commande_fk_user_author | CREATE INDEX idx_commande_fk_user_author ON llx_commande USING btree (fk_user_author) |
public | llx_commande | idx_commande_fk_user_cloture | CREATE INDEX idx_commande_fk_user_cloture ON llx_commande USING btree (fk_user_cloture) |
public | llx_commande | idx_commande_fk_user_valid | CREATE INDEX idx_commande_fk_user_valid ON llx_commande USING btree (fk_user_valid) |
public | llx_commande_extrafields | idx_commande_extrafields | CREATE INDEX idx_commande_extrafields ON llx_commande_extrafields USING btree (fk_object) |
public | llx_commande_fournisseur | idx_commande_fournisseur_fk_soc | CREATE INDEX idx_commande_fournisseur_fk_soc ON llx_commande_fournisseur USING btree (fk_soc) |
public | llx_commande_fournisseur_dispatch | idx_commande_fournisseur_dispatch_fk_commande | CREATE INDEX idx_commande_fournisseur_dispatch_fk_commande ON llx_commande_fournisseur_dispatch USING btree (fk_commande) |
public | llx_commande_fournisseur_extrafields | idx_commande_fournisseur_extrafields | CREATE INDEX idx_commande_fournisseur_extrafields ON llx_commande_fournisseur_extrafields USING btree (fk_object) |
public | llx_contrat | idx_contrat_fk_soc | CREATE INDEX idx_contrat_fk_soc ON llx_contrat USING btree (fk_soc) |
public | llx_contrat | idx_contrat_fk_user_author | CREATE INDEX idx_contrat_fk_user_author ON llx_contrat USING btree (fk_user_author) |
public | llx_contratdet | idx_contratdet_date_fin_validite | CREATE INDEX idx_contratdet_date_fin_validite ON llx_contratdet USING btree (date_fin_validite) |
public | llx_contratdet | idx_contratdet_date_ouverture | CREATE INDEX idx_contratdet_date_ouverture ON llx_contratdet USING btree (date_ouverture) |
public | llx_contratdet | idx_contratdet_date_ouverture_prevue | CREATE INDEX idx_contratdet_date_ouverture_prevue ON llx_contratdet USING btree (date_ouverture_prevue) |
public | llx_contratdet | idx_contratdet_fk_contrat | CREATE INDEX idx_contratdet_fk_contrat ON llx_contratdet USING btree (fk_contrat) |
public | llx_contratdet | idx_contratdet_fk_product | CREATE INDEX idx_contratdet_fk_product ON llx_contratdet USING btree (fk_product) |
public | llx_contratdet_log | idx_contratdet_log_date | CREATE INDEX idx_contratdet_log_date ON llx_contratdet_log USING btree (date) |
public | llx_contratdet_log | idx_contratdet_log_fk_contratdet | CREATE INDEX idx_contratdet_log_fk_contratdet ON llx_contratdet_log USING btree (fk_contratdet) |
public | llx_ecm_directories | idx_ecm_directories_fk_user_c | CREATE INDEX idx_ecm_directories_fk_user_c ON llx_ecm_directories USING btree (fk_user_c) |
public | llx_ecm_directories | idx_ecm_directories_fk_user_m | CREATE INDEX idx_ecm_directories_fk_user_m ON llx_ecm_directories USING btree (fk_user_m) |
public | llx_element_contact | fk_element_contact_fk_c_type_contact | CREATE INDEX fk_element_contact_fk_c_type_contact ON llx_element_contact USING btree (fk_c_type_contact) |
public | llx_events | idx_events_dateevent | CREATE INDEX idx_events_dateevent ON llx_events USING btree (dateevent) |
public | llx_expedition | idx_expedition_fk_shipping_method | CREATE INDEX idx_expedition_fk_shipping_method ON llx_expedition USING btree (fk_shipping_method) |
public | llx_expedition | idx_expedition_fk_soc | CREATE INDEX idx_expedition_fk_soc ON llx_expedition USING btree (fk_soc) |
public | llx_expedition | idx_expedition_fk_user_author | CREATE INDEX idx_expedition_fk_user_author ON llx_expedition USING btree (fk_user_author) |
public | llx_expedition | idx_expedition_fk_user_valid | CREATE INDEX idx_expedition_fk_user_valid ON llx_expedition USING btree (fk_user_valid) |
public | llx_expeditiondet | idx_expeditiondet_fk_expedition | CREATE INDEX idx_expeditiondet_fk_expedition ON llx_expeditiondet USING btree (fk_expedition) |
public | llx_facture | idx_facture_fk_account | CREATE INDEX idx_facture_fk_account ON llx_facture USING btree (fk_account) |
public | llx_facture | idx_facture_fk_user_author | CREATE INDEX idx_facture_fk_user_author ON llx_facture USING btree (fk_user_author) |
public | llx_facture_extrafields | idx_facture_extrafields | CREATE INDEX idx_facture_extrafields ON llx_facture_extrafields USING btree (fk_object) |
public | llx_facture_fourn | idx_facture_fourn_date_lim_reglement | CREATE INDEX idx_facture_fourn_date_lim_reglement ON llx_facture_fourn USING btree (date_lim_reglement) |
public | llx_facture_fourn | idx_facture_fourn_fk_user_valid | CREATE INDEX idx_facture_fourn_fk_user_valid ON llx_facture_fourn USING btree (fk_user_valid) |
public | llx_facture_rec | idx_facture_rec_fk_projet | CREATE INDEX idx_facture_rec_fk_projet ON llx_facture_rec USING btree (fk_projet) |
public | llx_facture_rec | idx_facture_rec_fk_soc | CREATE INDEX idx_facture_rec_fk_soc ON llx_facture_rec USING btree (fk_soc) |
public | llx_facture_rec | idx_facture_rec_fk_user_author | CREATE INDEX idx_facture_rec_fk_user_author ON llx_facture_rec USING btree (fk_user_author) |
public | llx_fichinter | idx_fichinter_fk_soc | CREATE INDEX idx_fichinter_fk_soc ON llx_fichinter USING btree (fk_soc) |
public | llx_fichinterdet | idx_fichinterdet_fk_fichinter | CREATE INDEX idx_fichinterdet_fk_fichinter ON llx_fichinterdet USING btree (fk_fichinter) |
public | llx_holiday | idx_holiday_date_debut | CREATE INDEX idx_holiday_date_debut ON llx_holiday USING btree (date_debut) |
public | llx_holiday | idx_holiday_date_fin | CREATE INDEX idx_holiday_date_fin ON llx_holiday USING btree (date_fin) |
public | llx_livraison | idx_livraison_fk_soc | CREATE INDEX idx_livraison_fk_soc ON llx_livraison USING btree (fk_soc) |
public | llx_livraison | idx_livraison_fk_user_author | CREATE INDEX idx_livraison_fk_user_author ON llx_livraison USING btree (fk_user_author) |
public | llx_livraison | idx_livraison_fk_user_valid | CREATE INDEX idx_livraison_fk_user_valid ON llx_livraison USING btree (fk_user_valid) |
public | llx_livraisondet | idx_livraisondet_fk_expedition | CREATE INDEX idx_livraisondet_fk_expedition ON llx_livraisondet USING btree (fk_livraison) |
public | llx_mailing_cibles | idx_mailing_cibles_email | CREATE INDEX idx_mailing_cibles_email ON llx_mailing_cibles USING btree (email) |
public | llx_menu | idx_menu_menuhandler_type | CREATE INDEX idx_menu_menuhandler_type ON llx_menu USING btree (menu_handler. type) |
public | llx_opensurvey_comments | idx_id_comment | CREATE INDEX idx_id_comment ON llx_opensurvey_comments USING btree (id_comment) |
public | llx_opensurvey_comments | idx_id_sondage | CREATE INDEX idx_id_sondage ON llx_opensurvey_comments USING btree (id_sondage) |
public | llx_opensurvey_sondage | idx_date_fin | CREATE INDEX idx_date_fin ON llx_opensurvey_sondage USING btree (date_fin) |
public | llx_opensurvey_sondage | idx_id_sondage_admin | CREATE INDEX idx_id_sondage_admin ON llx_opensurvey_sondage USING btree (id_sondage_admin) |
public | llx_opensurvey_user_studs | idx_opensurvey_user_studs_id_sondage | CREATE INDEX idx_opensurvey_user_studs_id_sondage ON llx_opensurvey_user_studs USING btree (id_sondage) |
public | llx_opensurvey_user_studs | idx_opensurvey_user_studs_id_users | CREATE INDEX idx_opensurvey_user_studs_id_users ON llx_opensurvey_user_studs USING btree (id_users) |
public | llx_opensurvey_user_studs | idx_opensurvey_user_studs_nom | CREATE INDEX idx_opensurvey_user_studs_nom ON llx_opensurvey_user_studs USING btree (nom) |
public | llx_paiementfourn_facturefourn | idx_paiementfourn_facturefourn_fk_paiement | CREATE INDEX idx_paiementfourn_facturefourn_fk_paiement ON llx_paiementfourn_facturefourn USING btree (fk_paiementfourn) |
public | llx_prelevement_facture | idx_prelevement_facture_fk_prelevement_lignes | CREATE INDEX idx_prelevement_facture_fk_prelevement_lignes ON llx_prelevement_facture USING btree (fk_prelevement_lignes) |
public | llx_prelevement_lignes | idx_prelevement_lignes_fk_prelevement_bons | CREATE INDEX idx_prelevement_lignes_fk_prelevement_bons ON llx_prelevement_lignes USING btree (fk_prelevement_bons) |
public | llx_product | idx_product_barcode | CREATE INDEX idx_product_barcode ON llx_product USING btree (barcode) |
public | llx_product | idx_product_import_key | CREATE INDEX idx_product_import_key ON llx_product USING btree (import_key) |
public | llx_product | idx_product_label | CREATE INDEX idx_product_label ON llx_product USING btree (label) |
public | llx_product_association | idx_product_association_fils | CREATE INDEX idx_product_association_fils ON llx_product_association USING btree (fk_product_fils) |
public | llx_product_extrafields | idx_product_extrafields | CREATE INDEX idx_product_extrafields ON llx_product_extrafields USING btree (fk_object) |
public | llx_product_fournisseur_price | idx_product_fourn_price_fk_product | CREATE INDEX idx_product_fourn_price_fk_product ON llx_product_fournisseur_price USING btree (fk_product. entity) |
public | llx_product_fournisseur_price | idx_product_fourn_price_fk_soc | CREATE INDEX idx_product_fourn_price_fk_soc ON llx_product_fournisseur_price USING btree (fk_soc. entity) |
public | llx_product_fournisseur_price | idx_product_fournisseur_price_fk_user | CREATE INDEX idx_product_fournisseur_price_fk_user ON llx_product_fournisseur_price USING btree (fk_user) |
public | llx_product_price_by_qty | idx_product_price_by_qty_fk_product_price | CREATE INDEX idx_product_price_by_qty_fk_product_price ON llx_product_price_by_qty USING btree (fk_product_price) |
public | llx_product_stock | idx_product_stock_fk_entrepot | CREATE INDEX idx_product_stock_fk_entrepot ON llx_product_stock USING btree (fk_entrepot) |
public | llx_product_stock | idx_product_stock_fk_product | CREATE INDEX idx_product_stock_fk_product ON llx_product_stock USING btree (fk_product) |
public | llx_projet | idx_projet_fk_soc | CREATE INDEX idx_projet_fk_soc ON llx_projet USING btree (fk_soc) |
public | llx_projet_extrafields | idx_projet_extrafields | CREATE INDEX idx_projet_extrafields ON llx_projet_extrafields USING btree (fk_object) |
public | llx_projet_task | idx_projet_task_fk_projet | CREATE INDEX idx_projet_task_fk_projet ON llx_projet_task USING btree (fk_projet) |
public | llx_projet_task | idx_projet_task_fk_user_creat | CREATE INDEX idx_projet_task_fk_user_creat ON llx_projet_task USING btree (fk_user_creat) |
public | llx_projet_task | idx_projet_task_fk_user_valid | CREATE INDEX idx_projet_task_fk_user_valid ON llx_projet_task USING btree (fk_user_valid) |
public | llx_projet_task_extrafields | idx_projet_task_extrafields | CREATE INDEX idx_projet_task_extrafields ON llx_projet_task_extrafields USING btree (fk_object) |
public | llx_propal | idx_propal_fk_account | CREATE INDEX idx_propal_fk_account ON llx_propal USING btree (fk_account) |
public | llx_propal | idx_propal_fk_user_author | CREATE INDEX idx_propal_fk_user_author ON llx_propal USING btree (fk_user_author) |
public | llx_propal | idx_propal_fk_user_cloture | CREATE INDEX idx_propal_fk_user_cloture ON llx_propal USING btree (fk_user_cloture) |
public | llx_propal | idx_propal_fk_user_valid | CREATE INDEX idx_propal_fk_user_valid ON llx_propal USING btree (fk_user_valid) |
public | llx_societe | idx_societe_user_creat | CREATE INDEX idx_societe_user_creat ON llx_societe USING btree (fk_user_creat) |
public | llx_societe | idx_societe_user_modif | CREATE INDEX idx_societe_user_modif ON llx_societe USING btree (fk_user_modif) |
public | llx_societe_extrafields | idx_societe_extrafields | CREATE INDEX idx_societe_extrafields ON llx_societe_extrafields USING btree (fk_object) |
public | llx_societe_remise_except | idx_societe_remise_except_fk_user | CREATE INDEX idx_societe_remise_except_fk_user ON llx_societe_remise_except USING btree (fk_user) |
public | llx_socpeople | idx_socpeople_fk_user_creat | CREATE INDEX idx_socpeople_fk_user_creat ON llx_socpeople USING btree (fk_user_creat) |
public | llx_socpeople_extrafields | idx_socpeople_extrafields | CREATE INDEX idx_socpeople_extrafields ON llx_socpeople_extrafields USING btree (fk_object) |
public | llx_stock_mouvement | idx_stock_mouvement_fk_entrepot | CREATE INDEX idx_stock_mouvement_fk_entrepot ON llx_stock_mouvement USING btree (fk_entrepot) |
public | llx_stock_mouvement | idx_stock_mouvement_fk_product | CREATE INDEX idx_stock_mouvement_fk_product ON llx_stock_mouvement USING btree (fk_product) |
public | llx_user | uk_user_fk_societe | CREATE INDEX uk_user_fk_societe ON llx_user USING btree (fk_societe) |
public | llx_user_extrafields | idx_user_extrafields | CREATE INDEX idx_user_extrafields ON llx_user_extrafields USING btree (fk_object) |
public | llx_usergroup_user | fk_usergroup_user_fk_user | CREATE INDEX fk_usergroup_user_fk_user ON llx_usergroup_user USING btree (fk_user) |
public | llx_usergroup_user | fk_usergroup_user_fk_usergroup | CREATE INDEX fk_usergroup_user_fk_usergroup ON llx_usergroup_user USING btree (fk_usergroup) |