Forum Discussion

VickyDev18's avatar
VickyDev18
Icon for Advocate II rankAdvocate II
2 years ago

Optimizing a query that seems optimal already

First off, do want to be clarify that I am not looking for a specific solution but more of a theoritcal answer.    I have a simple star schema model  with Financial data transactions and dimension ...
General Comment
Need Help
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

Look at the query plan.  Especially check for high numbers of records. Refactor your code to do aggregations earlier to reduce the cardinality as soon as possible (but not sooner)

 

Check for RI errors.  Substitute SUMMARIZE with SUMMARIZECOLUMNS.  Eliminate CallbackDataIDs.