Efficient Queries I

• Sorting like SELECT DISTINCT, GROUP BY, ORDER BY etc may be expensive

• Check for Cartesian Products, join all tables in query

• Always try to join PK’s or FK’s if possible

• Include PK’s, FK’s and UNIQUE INDEX columns in WHERE clause where possible

• Outer join is NOT default

• Help the database by giving as much information as you can

Notes: