Tip of the Month (April 2011)

Speeding Up a Filter

When you turn on a filter, sometimes it takes a while to turn on. This is especially true if there are many records in your database. There is something you can do to speed this up.

Say you have a filter criteria over an EMPLOYEE record such as:

AGE >
   30

DEPARTMENT =
   Toys

 x  Match All

The first thing you should do is put the "equals" criteria first:

DEPARTMENT =
   Toys

AGE >
   30

 x  Match All

Then, create an index over DEPARTMENT.

This should speed up the application of the filter.