1) What are three suggestions for improving query processing?
2) Of the three suggestions, how do they compare to the rules below? Are there differences, similarities, or conflicting definitions?
Suggestion 1: Don't combine a table with itself
Suggestion 2: Retrieve only the data you need
Suggestion 3: Understand how indexes are used in query processing
Suggestion 4: Consider the total query processing time for ad hoc queries
Suggestion 5: Break complex queries into multiple simple parts