Exadata - Storage Servers
About
Oracle Exadata Storage Servers combine Oracle's smart storage software and Oracle's industry-standard Sun hardware to deliver the industry's highest database storage performance.
Preconceptions/Observations
- Don’t use indexes. However, indexes are still useful when a specific rows required, e.g. tree-walking with CONNECT BY
PRIOR. Not required for bulk operations
- Use HASH partitioning
- A pivot operation on 80M rows completed in a < 10s
- If you have a Data Vault on Teradata, you don’t need to construct physical data marts. Everything, yes, everthing is virtual. The engine is so powerful, and so fast that virtual marts (views) work 100% of the time for your reporting needs – inclusive of business logic.