Slide 39
Slide 39 text
1 File 10 File 15 File 20 File
CTAS COPY Data Flow CTAS COPY Data Flow CTAS COPY Data Flow CTAS COPY Data Flow
Round Robin Heap 256 355 2,514 265 328 254 290 263 293
Column Store 320 364 297 342 308 373 315 351
Hash Heap 400 816 489 350 395 334 389 352
Column Store 393 847 382 472 409 391 401 370
60 File 100 File 500 File 1000 File
CTAS COPY Data Flow CTAS COPY Data Flow CTAS COPY Data Flow CTAS COPY Data Flow
Round Robin Heap 276 292 277 150 281 164 287 161
Column Store 311 309 309 207 309 205 336 241
Hash Heap 377 336 379 203 397 186 392 183
Column Store 384 386 412 261 392 248 371 249
1 File
2 vCore 4 vCore 6 vCore 10 vCore 20 vCore 40 vCore 80 vCore
General Purpose (Gen5) 3,150 1,604 1050 812 853 838 931
Business Critical (Gen5) 1,208 857 792 729 756 784 963
Hyperscale (Gen5) 1,429 913 1,027 1,859 1,979 1,854 3,667
2 vCore 4 vCore 6 vCore 10 vCore 20 vCore 40 vCore 80 vCore
General Purpose (Gen5) 9Mbps 18Mbps 27Mbps 45Mbps 50Mbps 50Mbps 50Mbps
Business Critical (Gen5) 24Mbps 48Mbps 72Mbps 96Mbps 96Mbps 96Mbps 96Mbps
Hyperscale (Gen5) 100Mbps 100Mbps 100Mbps 100Mbps 100Mbps 100Mbps 100Mbps
1 File
P1 P2 P4 P6 P11 P15
Premium 4,723 2,362 1,180 829 747 859