Tables and Indexes

Topics

• Case Sensitivity Differences for Oracle and PostgreSQL
• Common Data Types
• Oracle Read-Only Tables and Partitions and PostgreSQL Aurora Replicas
• Table Constraints
• Temporary Tables
• Oracle Triggers and PostgreSQL Trigger Procedure
• Tablespaces and Data Files
• User-Defined Types
• Oracle Unused Columns and PostgreSQL Alter Table
• Oracle Virtual Columns and PostgreSQL Views and Functions
• Overall Indexes Summary
• Oracle Bitmap Indexes and PostgreSQL Bitmap
• B-Tree Indexes
• Oracle Composite Indexes and PostgreSQL Multi-Column Indexes
• Oracle Function-Based Indexes and PostgreSQL Expression Indexes
• Invisible Indexes
• Oracle Index-Organized Table and PostgreSQL Cluster Table
• Oracle Local and Global Partitioned Indexes and PostgreSQL Partitioned Indexes
• Oracle Automatic Indexing and Self-Managed PostgreSQL