What is the difference between both Plan Analyzer rule sets delivered with the product ?
_ @@RULDBA Rule Set for DBA
_ @@RULDEV Rule Set for Developer
These are the role based CA-Defined rule sets that were made available in r18. While the rule sets are not update-able. It can be easily templated to allow the ability to customize them.
@@RULDBA - contains all the rules SQL, Physical, Plan, and Predicate with exception of Physical RI rules 1056-1061.
@@RULDEV - contains only the SQL and Predicate rules.