Multiple choice technology programming languages

Which of the following statements is false wrt Improving Query Performance.

  1. Omitting the ORDER BY clause when you create tables and views improve the query performance.

  2. using joins instead of subqueries improve the query performance.

  3. A good practice to improve query performance is using WHERE expressions to limit the size of result tables created with joins.

  4. Must use the ORDER BY clause when you create tables and views.
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

ORDER BY is an optional clause when creating tables and views, used only to sort the result set. Omitting it can improve performance by avoiding unnecessary sorting. WHERE clauses are recommended to limit result sizes. Using joins instead of subqueries is a performance best practice.

Keep practicing — related questions