|
TruTek can implement partitioning in your Oracle database with resulting increases in manageability, performance and availability
|
|
|  | - Increases MANAGEABILITY rolling windows, decreased maintenance time-frames, divide and conquer
- Increases PERFORMANCE partition elimination, partition-wise join, data placement
- Increases AVAILABILITY protect against hardware failure, (sub)partition level maintenance operations
|
|
|
|  | | | CREATE TABLE locations (
location_id, street_address, postal_code,
city, state_province, country_id )
PARTITION BY LIST (state_province)
STORAGE(INITIAL 10K NEXT 20K) TABLESPACE tbs5
(
PARTITION region_east
VALUES ('MA','NY','CT','NH','ME','MD','VA','PA','NJ')
STORAGE (INITIAL 20K NEXT 40K PCTINCREASE 50)
TABLESPACE tbs8, ……. | New for 9i
- User controls how rows map to partitions
- No relationship between partitions
- Ideal for columns that consist of discrete values
- Multi-column partitioning not supported
- NULL can be specified as a partition literal value
|
|
| - Increases MANAGEABILITY rolling windows, decreased maintenance time-frames, divide and conquer
- Increases PERFORMANCE partition elimination, partition-wise join, data placement
- Increases AVAILABILITY protect against hardware failure, (sub)partition level maintenance operations
|
|
|
|
|
