Performance: Querying on revenueID takes longer than other revenue fields

When a user queries on a specific revenueID the results take just over 10 seconds to return.  When querying on other revenue fields are queried the results return almost instantly.
Download and install the latest patch, which contains all fixes from previous patches. If you are running an older version, download and install the latest version and then the patch. 

Environment

 2.93.2034.81
 3.0.516, Service Pack 3 ; 2.93.2034, patch 90 ; 2.94.1524, patch 79

Was this article helpful?