Optimizing Data Warehousing for Large Scale Policy Management Using Advanced ETL Frameworks

Table 2.

Query LatencyModel

Plan Estimated Latency (s)

Scan 278150.0
Index only 3700.0594
Index + Partition Pruning 308.38613333333336