What are the considerations in performing query optimization?
use and have a look into these references:
1- this one you 100% have to use:
2- this is a good explanation:
3- this is an example of google.. and the negative/positive considerations for query optimisation at google: