Test Results IV First Row Searches

• Goal: Simulate optimal usage pattern in forms based query tools.

• Approach: Constrain query to return only first 10 rows.

• SQL:

  • select count(*) from TEST_SMILES where DDUSER.CONTAINS(smiles, . . .) and ROWNUM <= 10;
  • select count(*) from TEST_SMILES where DDUSER.MATCHES(smiles, . . .) and ROWNUM <= 10;

Notes: