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

using joins instead of subqueries improve the query performance.

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

Must use the ORDER BY clause when you create tables and views.