Data warehouse query runs long

A data warehouse query that ran in 1 second in version 2.94 takes 40 seconds in 4.0
We're currently evaluating this issue for a fix in a future patch or service pack.

Steps to Duplicate

Run the following directly in SQL Server Management Studio against your BBDW database:

select fr.revenuefactid, *
from bbdw.DIM_CONSTITUENT dc
       join bbdw.FACT_REVENUE fr on dc.CONSTITUENTDIMID = fr.CONSTITUENTDIMID where dc.CONSTITUENTLOOKUPID = ''
 

Environment

 Blackbaud CRM
 4.0
 4.0.141.9

Was this article helpful?