OM Plus: Test the Performance of SQL Queries

Test your SQL queries in Order Management Plus databases to see if they are working or need further optimization.

The Database SQL Query Runner provides information that indicates whether a query is running efficiently or is out of normal boundaries.

Note

To be able to test SQL queries, ensure that the OM Plus user profile (not the Salesforce user profile) has the Database SQL Query Executor profile assigned to it. See OM Plus:­ Assign a User Profile to a User.

To test the performance of SQL queries in OM Plus databases, follow these steps:

1. In Lightning Experience, click the App Launcher:
2. Begin to type XOM Administration until Vlocity XOM Administration appears in the list.
3. Click Vlocity XOM Administration. The Vlocity XOM Administration page opens.
4. In the Vlocity XOM Administration page, in the OM Plus DB Query Runner section, click Open.

   In the OM Plus DB Query Runner page, the database tables that you can query are shown in the Limitations section to the right:

   

   For more information about the OM Plus database structure and tables, view or download the following document: OM Plus Database Design

5. In the Please enter your SQL query section, enter your SQL query. For example, select * from vloc_objects where id > 1000 limit 10

   The maximum limit of the number of results is 500.

6. Click one of the buttons to run your query:

   • Explain: Returns the query plan.

   • Explain Analyze: Returns the query plan, row count, and run time (planning time and execution time).

   • Execute: Returns the database rows.

   

   Note

   You can run a maximum of six queries per minute. If you enter an invalid query, an error message is shown underneath the buttons:

The query results are shown in a section underneath the buttons:

Note

If an authorization error appears, you may need to clear the security cache for the user. To see how to clear the security cache, follow the steps in OM Plus:­ Assign a User Profile to a User.