 	WHERE name='id_valid_status_for_profiles'
 	)
 GROUP BY t.cd_ref;
+
+CREATE UNIQUE INDEX ON gn_profiles.vm_valid_profiles (cd_ref);
 
 CREATE MATERIALIZED VIEW gn_profiles.vm_cor_taxon_phenology AS 
 WITH classified_data AS (

LEFT JOIN taxonomie.taxref t ON p.cd_nom=t.cd_nom;


-----------
-- INDEX --
-----------

from classified_data
;

CREATE UNIQUE INDEX ON gn_profiles.vm_cor_taxon_phenology (cd_ref, period);

CREATE VIEW gn_profiles.v_consistancy_data AS
SELECT 
