Run Code  | API  | Code Wall  | Misc  | Feedback  | Login  | Theme  | Privacy  | Patreon 

Cross Tab vs Pivot - Pre Aggregated with cte

Language: Layout:
View schema
Execution time: 7,58 sec, rows selected: 5, rows affected: 300005, absolute service time: 8,28 sec 
edit mode |  history
   what started ended DurationInMs
1 Start Feb 19 2017 7:25PM Feb 19 2017 7:25PM NULL
2 Finished Loading Test Data Feb 19 2017 7:25PM Feb 19 2017 7:26PM 5723
3 Finished Prep Feb 19 2017 7:26PM Feb 19 2017 7:26PM 950
4 Finished "Pre-aggregated" Pivot with CTE Feb 19 2017 7:26PM Feb 19 2017 7:26PM 580
5 Finished "Pre-aggregated" Cross Tab with CTE Feb 19 2017 7:26PM Feb 19 2017 7:26PM 323