Query Analysis and Index Tuning

Share this post!

Vote this!

After you have implemented your system, a year or so down the live you generally hear users stating that reports are taking longer and the system is a little sluggish, in this section we will take a look at how to address these issues which generally all relate to concurrency, more users using the system

• The query cache is not being utilized properly
• The query contains subqueries or unoptimized subqueries
• The table contains large amounts of unnecessary data                          more...