InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
What Is An Optimization And Performance Tuning And How Does It Really Work In Practical Projects? |
|
Answer» Performance tuning and OPTIMIZATION of a QUERY involves collecting statistics on join columns, avoiding cross product join, selection of appropriate primary INDEX (to AVOID skewness in storage) and USING secondary index. Performance tuning and optimization of a query involves collecting statistics on join columns, avoiding cross product join, selection of appropriate primary index (to avoid skewness in storage) and using secondary index. |
|