Partial indexes

From DISI
Jump to navigation Jump to search

incremental partial indexes

as of Oct 1, 2016

create index ix_substance_smiles_current_031 on substance using gist (smiles) where purchasable>0 and sub_id between 600000000 and 619999999;
create index ix_fp_ecfp4_data_028 on fingerprints.ecfp4_new using gist (data) where ecfp4_fk between 270000000 and 279999999;

[[Category::Curator]]