Partitioning
Information about what partitioning methods are supported natively.
Range | Hash | Composite (Range+Hash) | List | Expression | |
---|---|---|---|---|---|
4th Dimension | ? | ? | ? | ? | |
ADABAS | ? | ? | ? | ? | |
Adaptive Server Enterprise | Yes | Yes | No | Yes | |
Advantage Database Server | No | No | No | No | |
Altibase | Yes | Yes | No | Yes | |
Apache Derby | No | No | No | No | |
CUBRID | Yes | Yes | No | Yes | |
IBM DB2 | Yes | Yes | Yes | Yes | |
Empress Embedded Database | No | No | No | No | |
Firebird | No | No | No | No | |
HSQLDB | No | No | No | No | |
H2 | No | No | No | No | |
Informix Dynamic Server | Yes | Yes | Yes | Yes | Yes |
Ingres | Yes | Yes | Yes | Yes | |
InterBase | No | No | No | No | |
Linter SQL RDBMS | No | No | No | No | |
MaxDB | No | No | No | No | |
Microsoft Access (JET) | No | No | No | No | |
Microsoft Visual Foxpro | No | No | No | No | |
Microsoft SQL Server | Yes | No | No | No | |
Microsoft SQL Server Compact (Embedded Database) | No | No | No | No | |
MonetDB | Yes (M5) | Yes (M5) | Yes (M5) | No | |
MySQL | Yes | Yes | Yes | Yes | |
OpenBase SQL | ? | ? | ? | ? | |
Oracle | Yes | Yes | Yes | Yes | |
Oracle Rdb | Yes | Yes | ? | ? | |
OpenLink Virtuoso | Yes | No | No | No | |
Polyhedra DBMS | No | No | No | No | |
PostgreSQL | Yes1 | Yes1 | Yes1 | Yes1 | |
RDM Embedded | Yes2 | Yes2 | Yes2 | No | |
RDM Server | No | No | No | No | |
ScimoreDB | No | Yes | No | No | |
SQL Anywhere | No | No | No | No | |
SQLite | No | No | No | No | |
Teradata | Yes | Yes | Yes | Yes | |
UniVerse | Yes | Yes | Yes | Yes | |
Xeround Cloud Database | N/A - partitioning provided transparently | N/A - partitioning provided transparently | N/A - partitioning provided transparently | N/A - partitioning provided transparently | |
Range | Hash | Composite (Range+Hash) | List |
Note (1): PostgreSQL 8.1 provides partitioning support through check constraints. Range, List and Hash methods can be emulated with PL/pgSQL or other procedural languages.
Note (2): RDM Embedded 10.1 requires the application programs to select the correct partition (using range, hash or composite techniques) when adding data, but the database union functionality allows all partitions to be read as a single database.
Read more about this topic: Comparison Of Relational Database Management Systems