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. Click Designer Studio > 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.