Forum Discussion
Incremental refresh vs Historization
Hello! Let's say I have a table called Products: when a product is added or either edited, i receive a new row in my database. Unfortunately these are duplicated, so I would have a row like: Pr...
Thanks to you both!
To give you a few extra details:
The data source is Azure synapse analytics
We don't perform too complex operations, we usually JOIN two tables and use a similar operation to get the latest rows:
....Select statement
ROW_NUMBER() OVER (PARTITION BY [PRODUCT ID], [TYPE] ORDER BY [TIMESTAMP] DESC) AS rownumber
....
from sourcedata where rownumber = 1
Unfortunately we need all data displayed, we don't need aggregations, we need only a simple table and a few slicers. We would only need for the report to load a bit faster than it is currently.
Do you have well maintained indexes (indices) on these three columns?