Test Results II Index Creation

• Index on SMILES column

  • SQL: CREATE INDEX s1 ON test_smiles(smiles) INDEXTYPE IS ddblob PARAMETERS ('fpsize=1024');
  • Index creation time: 79 min.

• Population of FP column

  • In parallel with two CPUs using two sessions
  • 30 min. elapsed

• Index on FP column

  • SQL: CREATE INDEX s1 ON test_smiles(fp) INDEXTYPE IS ddblob;
  • Index creation time: 2 min. 4 sec.!!!

Notes: