Les08-排序关联.pptVIP

Sorting and Joining Objectives After completing this lesson, you should be able to do the following: Optimize sort performance Describe different join techniques Explain join optimization Find optimal join execution plans Sort Operations SORT UNIQUE SORT AGGREGATE SORT GROUP BY SORT JOIN SORT ORDER BY Tuning Sort Performance Sorting large sets can be expensive, so you should tune sort parameters. Note that DISTINCT, GROequijoind most set operators cause implicit sorts. Minimize sorting by one of the following: Try to avoid DISTINCT and GROUP BY. Use UNION ALL instead of UNION. Enable index