SQL Query Optimization

Share this post!

Vote this!

Performance tuning focuses on writing efficient SQL, allocating computer resources and analyzing wait events and contention in the system. The design approach to a database is critical to ensuring the best performance from a database, here are the steps when designing a database:

1. Design the application correctly
2. Tune the application SQL code
3. Tune memory
4. Tune I/O
5. Tune contention and other issues

There are two approaches to performance tuning  more...