Lets try it !


This page demonstrates creation of ranges on the first fact table to improve query processing by creating partitions to store different ranges of data.

Operation


Note : If the tablespaces are already created, the SQLs may fail. Ignore the failed statements in this case.


  1. Create separate tablespaces to store different ranges of data and indexes. This has the following advantages :
  2. Create table 'subscriber_rated_usage_range' enabled with range partitioning
  3. Populate data into the table. Data is stored in separate ranges based on the partitioning key specified