A continuable query might have no WHERE clause. A composite index might improve the performance of such a query.
Content Platform Engine SQL | Corresponding database SQL (continuable query) |
---|---|
|
|
CREATE INDEX I_OCID_ID
ON DocVersion (object_class_id, object_id)
If there are subclasses of DocClass, the database SQL includes the following condition: object_class_id IN (?, ?). In this situation, a sort step on object_id is still required, and so an index on object_class_id alone is sufficient.