Click on the action buttons in the action panel to get the query execution times for tables with and without range partitions and generate a graph comparing the same
Results may vary depending on the volume of data. For optimal performance, use high volume of data.
To increase the volume of data, load the fact tables 'te_temp.subscriber_rated_usage' and 'te_temp.subscriber_dedicated_account_usage' with the corresponding .del files present in the LoadFiles directory.
OperationQuery execution times for tables enabled with DPF + Indexes + RPF, DPF + Indexes, DPF + Indexes and DPF are computed
The query execution time is greatly reduced with the creation of range partitioned tables
Range partitioning helps reduce network traffic as data pertaining to a particular query predicate may reside in one range. Manageability of such data becomes easier too.
An explain snapshot is compressed information that is collected when an SQL statement is explained. It contains
Run the following steps on the DB2 CLP window to view the explain snapshot :
designdb
.query_RP.db2
replace 'SCHEMA' with the Default Schema.query_RP.db2
designdb
-1 -o explain_RP.out
. The Explain Plan can be viewed in the output file explain_RP.out
.Click here to view the sample output of the Explain Access Plan : Sample Explain Access Plan