There is a standard method of optimization - breaking predicate into smaller ones and saving intermediates into database. Typically program runs efficiently, b

There is a standard method of optimization - breaking predicate into smaller ones and saving intermediates into database. Typically program runs efficiently, but when optimization is needed - you can do it by breaking up the predicate.