Oracle also supports Hash based partitioning for fragmentation. It can do so in order to create the main partitions or for sub-partitions it further in conjunction with RANGE-HASH, HASH-RANGE, LIST-HASH, HASH-LIST, or HASH-HASH partitioning.
Tag: Database
Lab on LIST PARTITIONING in ORACLE 18C
Partitioning in Oracle allows to subdivide a whole large logical object like table into smaller physical objects termed as partitions using some list of values as well .
Replication Using CockroachDB
Replication is important in distributed databases. The cockroachDB uses minimum of three node quorum to establish replication in clusters. A single-node cluster is not appropriate for use in production or for performance testing. To run a multi-node cluster with replicated data for availability, consistency and resiliency, including load balancing across multiple nodes, use cockroach start and cockroach init to start a multi-node cluster with a minimum of three nodes instead.