[Enterprise Extensions only]
  Previous topic

Using indexes to improve performance

Creating an index over the database table that is used to store rules is an important way to improve the performance of rule queries. It is recommended that an index be created over the rulename column of the table containing the rules. This greatly improves the performance of rule-triggered queries that are looking for a rule(s) with a specific name. The index saves teh query the effort of searching every row in the table. Please refer to the documentation for your database for instructions on how to create an index.

  Previous topic