Generating an explain plan

You can generate an explain plan to help tune an SQL query.

Note: You need the PegaRULES:DatabaseAdministrator role to access the Query Inspector.
  1. In the header of Dev Studio, click Configure > System > Database > Query Inspector.
  2. Select the database from the Choose your database list.
  3. Enter or paste an SQL query into the Enter or paste statement to evaluate here field.
  4. Click Generate explain plan.