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 To create a variable, select Creat Variable and complete the fields. To modify a variable, select
> Edit and enter a new value.To delete a variable, select
> Delete, then Delete to confirm.Formulas To modify a formula, select > Edit, then select new fields, functions, or variables.To delete a formula, select
> Delete, then Delete to confirm.SQL Select Generate SQL to view the SQL. Explain - Select Generate SQL from the SQL tab.
- Select Explain SQL to view the EXPLAIN plan provided by the database.
- Select Save.