Ismael,

You have probably already done this but make sure you have a DELE() index key for all your data tables. If you do not the Filter will not be optimized no matter what you do.

Secondly, if you want, run your SQL to retreive the primary key of the table that meets you filtering criteria. Then set this temp table as the super parent at the top of the relationship. Then skip down thru it instead of your parent.

Hope this helps!

Regards,

Jim Smith