Resolution:
Description:
============
TIBCO BusinessEvents takes a long time to build Rule Agenda.

Environment:
============
TIBCO BusinessEvents 3.x, 4.x, 5.x
All Operating System

Cause:
====
There are a lot of instances of one type loaded and they all go into a join table.

Resolution:
========
1). Check the rules to see what join table could be filling up with objects and remove  the objects from the scope.

2). Try to add a filter condition that reduces the number of objects going to the join table from all the rules.

3). Re-order the join conditions so that more selective ones are first.

Note: TIBCO BusinessEvents always puts filters before joins so it may not help only to reorder filter conditions before joins.