Query Optimization

• Retrieve only necessary rows.

• Do not use *; instead, specify the columns.

• Create views so users will control the data pull as well as security.

• Filter first and Join later.

• Filter first and Group later.

• Monitor queries regularly for performance.

• Index only when needed. Please don't index unwanted columns.