What is the difference between both Plan Analyzer rule sets delivered with the product ?

Document ID : KB000016449
Last Modified Date : 14/02/2018
Show Technical Document Details
Question:

What is the difference between both Plan Analyzer rule sets delivered with the product ?

_  @@RULDBA Rule Set for DBA       

_  @@RULDEV Rule Set for Developer

Answer:

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.