Query Fundamentals
Adam Wright
Query fundamentals What makes a good query? Query Styles Query Aspects What makes a good query? It has a specific purpose A good query has a specific purpose. It answers a particular question.
Examples:
What were the top 5 products sold last month? Which developer made the most commits today? What items need to be ordered? Specific queries can often be better optimized.
It is perceived as being fast Users expect applications to appear to work as fast as possible.