Optimize data model for improving performance | Product Feedback Forum

ccoelho · 2025-02-26T17:04:13.038000Z

Currently the way the Sisense creates its query for dashboards, is it creates a common table expression for each entity created in the data model. Then applies the date filter after the join between the CTE. During this process, it looks like its scanning the entire table of the CTE, which can be problematic if the underlying table used in the CTE is really large. It will be better if the filter for dates can be applied within the CTE for such large tables, thus avoiding large table scans and help load the report faster.Is there a way this can be achieved by altering the design of the data model? or are there any plugins to support it?

MoreDiscussions

Optimize data model for improving performance | Product Feedback Forum | Sisense Community