Script calculations or Set analysis?

[#1]

Hi all,

I would like to know, as a best practice, which methodology is better?

to do all possible calculations in the script and create more calculated data tables in memory, or,

do the calculations using set analysis?

what are the trade-offs?

Thanks,

Boris

[its_anandrjs]

Try to create good data model for the application and follow one of the data modelling techniques like

Star Schema or Snowflake Schema, best is Star Schema.

Regards

[#3]

I am using a star schema, but still I have to use a lot of set analysis due to complex charts I need to calculate.

my questions is in terms of performance, what are the trade-offs in building more calculated tables in memory or doing the calculations in the set analysis?