Many Cps Path Queries could be sped up by looking for the parent fragment first.

For example, given a query with leaf condition

/dmi-registry/cm-handles[@alternate-id="alt-1"]

This would result in the generated SQL having to  sequentially scan every fragment in the DB table to find fragments with that 'alternate-id' attribute.

If we first looked for '/dmi-registry', the SQL query would only check the direct children, greatly improving performance.