Partial indexes
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]]