Querying for gifts that have one or more specific funds (either in a gift or constituent query) by doing "one of" or an OR sequence of "equals" criteria takes several minutes. This is a common query need e.g. for determining donors to a specific area or for financial reporting.

I would appreciate if the blackbaud team could look into options to speed up these types of queries, e.g. if there is a missing database index that would improve performance for "gift by fund" queries.