cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

IDT Universe best practices : Better to have many derived tables or one long SQL script ?

mush
Explorer
0 Kudos
174

Hi everyone, 

My universe is taking a long time to load. Currently I'm using a long SQL script (more than 17.000 caracters) that includes temporary tables. 

I'm wondering if replacing those temporary tables with derived tables might improve performance.

Has anyone encountered a similar situation or tried this approach ? 

Thanks in advance ! 

Accepted Solutions (0)

Answers (0)