Data base Optimization

Database is the most important and powerful part of any application. If your database is not working properly and taking long time to compute the result, this means something is going wrong in database.

1. ·         Use  index on table
2. ·         Use  to Avoid Null value in fixed length field
3. ·         Use  Appropriate Datatype
4. ·         Use  Common Table Expressions (CTEs) instead of Temp table
5. ·         Use  Appropriate Naming Convention
6. ·         Use  UNION ALL instead of UNION
7. ·         Use  Small data type for Index 
8. Use  the stored procedure because stored procedures are fast and easy to maintain for