Query Optimization

These are some basic best practices. There is lot more to discuss in future sessions.

• 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.