After setting up WHERE and HAVING conditions, you can view a summary of the rule and make any changes. The system automatically creates a Rule ID.
- [Optional] From Rule summary, enter a Description.
To verify and add values to rule settings:
Tab Description VARIABLES
View the rule variable.
To create a variable, click CREATE VARIABLE and complete the fields.
To modify a variable, selectand enter a new value.
To delete a variable, select DELETE to confirm., then
View the formula.
To modify a formula, select, then select new fields, functions, or variables.
To delete a formula, select DELETE to confirm., then
View the SQL.
Click GENERATE SQL to view the SQL.
View the Explain SQL.
- Click GENERATE SQL from the SQL tab.
- Click EXPLAIN SQL to view the EXPLAIN plan provided by the database.
- Click SAVE.