Administer > Database Administration > Data persistence > Queries > Cross-table join query improvements

Cross-table join query improvements

The performance when running a join across database tables has been vastly improved as compared to version of Service Manager prior to 9.32. Previously, a query running across two tables was performed in memory by Service Manager. For data sets that contain millions of records, this process could be extremely time consuming.

The mechanism by which Service Manager executes queries across tables was changed in Service Manager 9.32. With the new mechanism, the initial Service Manager query is parsed, translated into SQL, and then issued directly to the RDBMS. The RDBMS then handles the initial join operation and returns a subset of results to Service Manager. However, because the database now performs this work, a number of limitations are imposed.  For more information on these limitations, see Limitations on cross-table join queries

Additionally, the new functionality is limited to the Service Manager functions on the Cross-table join functions.