Performance * virtual pivot table vs aggregate view * select * from pivot_table where attribute_001=X; X rows aggregate virtual (first) virtual (second) --- ---- ----------- -------------- ---------------- 0 0 3.4 0.5 0.1 seconds 1 2 3.4 0.5 0.1 2 2 3.4 0.5 0.1 3 2 3.4 0.5 0.1 10 3 3.4 0.5 0.2 20 2 3.4 0.5 0.1 30 2 3.4 0.5 0.1 40 4 3.4 0.5 0.2 50 1 3.4 0.5 0.1 100 2 3.4 0.5 0.1 200 3 3.4 0.5 0.2 500 0 3.4 0.4 0.1