Performance improvements for child case queries
If your application makes heavy use of child case queries, performance might be improved by adding indexes to some of your database tables. To improve the performance of child case queries, add a database index to each of your work tables by using a multicolumn index on the pxCoverInsKey, pxObjClass, and pyStatusWork columns. For existing tables, it can be beneficial to add more columns to the index, depending on the nature of the queries in your application. Queries that do not use all the columns in the index should still take advantage of the database index, provided that the first filter criterion is pxCoverInsKey. Note that the more columns an index has, the slower the writes to the table are.