Hi,
Interesting question. Do you want to be able to answer to someone about something you cannot do?
In brief, query optimization is all about analyzing data access paths of the query (or queries) and optimizing those paths. This can be done by applying indexing strategies or by rewriting the query.
The above is true only if you have a system that does not have resource bottlenecks. If you have system with resource bottlenecks, first you have to deal with them and then optimize the queries. Only if you think that poor queries and indexing is the reason of system resource bottlenecks you can start optimize the queries to resolve overall system performance state.
HTH, Regards, Dean Savović
No comments:
Post a Comment