Tag Archives: sql-query-optimization

SQL Optimization Techniques

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