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.
- Create separate tablespaces to store different ranges of data and indexes. This has the following advantages :
- Reduce the possibility of data corruption in multiple partitions
- Back up and recover each partition independently
- Improve manageability, availability and performance
- Create table 'subscriber_rated_usage_range' enabled with range partitioning
- Populate data into the table. Data is stored in separate ranges based on the partitioning key specified