Why SQL is not relational: Physical/Logical Confusion

• SQL does not do a good job of separating physical and logical implementation
• Indexes are physical but unique indexes are logical (keys) and physical
• Lack of options for optimizing storage separately from logical implementation
• Leads to solutions at the logical layer like denormalization