Skip to Content

Plan Viz analysis.

Hi All.

I was optimizing data model (calculation view) which is processing a huge amount of data and is taking a lot of time to execute. I analyzed and fond that I can use some Input parameter to restrict the data in lower level that filtering it in report. While analyzing the Plan Viz, I am noticing three things:

1. The Memory allocated is reduced by around 10X. Previously it was 103 GB, now it is 12 GB.

2. The number of table was 2 (the data model is joined with another db table for authorization purpose) and now it is 18.

3. The execution time is more than doubled now. I suspect because of more number of table access it increased.

Could someone explain, why the number of table access increased and even though it is processing very less data, why it is taking almost double the execution time?

original model:

model with IP:

Note that, the model is intact other than the Input parameter addition.



original.jpg (74.8 kB)
optimized.jpg (73.0 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers