Hash partitioning - 0 views
-
- instead of having a 100 gig tablespace to backup, you have 100, 1 gig tablespaces. (each tablespace spends less time in backup mode, reduces the amount of potential extra redo, reduces the amount of manual recovery you need to do if the instance failes during backup). same with restores.
-
every single admin option you do to a partition applies to a hash partition
-
Say you do a join on the hash partition key -- we can do parallel partition wise elimination on the join
- ...6 more annotations...