Tag Archives: oracle-sql-optimization

SQL Optimization Techniques

Posted on June 23, 2017 by Hiren Kubavat

Optimize access structures: Database design and normalization. Tables: heap or index-organized tables, and table or indexed clusters. Indexes. Constraints. Materialized views. Partitioning schemes. Statistics, including a comprehensive refresh strategy. Rewrite SQL statements: Exclude projections that are not required. Minimize the … Continue reading →

Posted in MysQl | Tagged , , , | Leave a comment