Redundant indexes on dolibarr database
List of useless indexe because they are redundant.
Contained | Containing |
---|---|
CREATE INDEX idx_categorie_fournisseur_fk_categorie ON llx_categorie_fournisseur USING btree (fk_categorie) | CREATE UNIQUE INDEX llx_categorie_fournisseur_pkey ON llx_categorie_fournisseur USING btree (fk_categorie. fk_societe) |
CREATE INDEX idx_categorie_member_fk_categorie ON llx_categorie_member USING btree (fk_categorie) | CREATE UNIQUE INDEX llx_categorie_member_pkey ON llx_categorie_member USING btree (fk_categorie. fk_member) |
CREATE INDEX idx_categorie_product_fk_categorie ON llx_categorie_product USING btree (fk_categorie) | CREATE UNIQUE INDEX llx_categorie_product_pkey ON llx_categorie_product USING btree (fk_categorie. fk_product) |
CREATE INDEX idx_categorie_societe_fk_categorie ON llx_categorie_societe USING btree (fk_categorie) | CREATE UNIQUE INDEX llx_categorie_societe_pkey ON llx_categorie_societe USING btree (fk_categorie. fk_societe) |
CREATE INDEX idx_paiement_facture_fk_paiement ON llx_paiement_facture USING btree (fk_paiement) | CREATE UNIQUE INDEX uk_paiement_facture ON llx_paiement_facture USING btree (fk_paiement. fk_facture) |
CREATE INDEX idx_paiementfourn_facturefourn_fk_paiement ON llx_paiementfourn_facturefourn USING btree (fk_paiementfourn) | CREATE UNIQUE INDEX uk_paiementfourn_facturefourn ON llx_paiementfourn_facturefourn USING btree (fk_paiementfourn. fk_facturefourn) |
CREATE INDEX idx_product_price_by_qty_fk_product_price ON llx_product_price_by_qty USING btree (fk_product_price) | CREATE UNIQUE INDEX uk_product_price_by_qty_level ON llx_product_price_by_qty USING btree (fk_product_price. quantity) |
CREATE INDEX idx_product_stock_fk_product ON llx_product_stock USING btree (fk_product) | CREATE UNIQUE INDEX uk_product_stock ON llx_product_stock USING btree (fk_product. fk_entrepot) |