Forum Discussion

Tim's avatar
Tim
Data Integration
01-13-2025
Solved

Query Plan Analyzer - is it reliable?

Looks to me like the Query Plan Analyzer incorrectly labels some joins as "many" when they should be "one". Also, it seems to analyze the SQL constructed by Sisense, not the database's query plan. Is...
  • Tim's avatar
    08-05-2025

    Sisense's R&D team analyzed this issue and clarified that model statistics is not updated after every build.
    There is a configuration that defines how long collected statistics are considered valid.
    Please go to Admin tab - Configuration - -5 clicks on Sisense logo - Base Configuration - base.modelStatistics.freshHoursInterval.value.
    Value in this field is the amount of hours the model statistics is valid. In case you need model statistics to be updated after every build, set this value to 0.

    I guess the only downside to updating statistics after every build is that it makes the build take a little longer. I guess it usually only matters if you've been modifying the underlying data or views in a way that might change whether a member of a dimension has many or one rows.