<blockquote>
<ol>
<li>Use of minimal columns in table creation. (max 100 columns).</li>
</ol>
</blockquote>
<ol>
<li>Avoid use of distinct; use ‘group by’ instead.
</li>
<li>Use of LIMIT when fetching records.
</li>
<li>Avoid use of * in the select statement. Define columns instead.
</li>
<li>Indexing tables. Try using composite indexing.
</li>
<li>Avoid use of wildcards(%) for example %abc%. Use instead abc%.
</li>
<li>Use of Union in place of "OR" condition.
</li>
<li>Try to minimize the length of column
</li>
<li>De-structuring : Projection and selection strategies
</li>
</ol>

> 1. Use of minimal columns in table creation. (max 100 columns).
>     

1. Avoid use of distinct; use ‘group by’ instead.
    
2. Use of LIMIT when fetching records.
    
3. Avoid use of \* in the select statement. Define columns instead.
    
4. Indexing tables. Try using composite indexing.
    
5. Avoid use of wildcards(%) for example %abc%. Use instead abc%.
    
6. Use of Union in place of "OR" condition.
    
7. Try to minimize the length of column
    
8. De-structuring : Projection and selection strategies

How to optimize SQL ?

Experienced Java/JavaScript full-stack developer with 5 years of extensive expertise serving key role on elite technical teams developing and designing software.
