Thank you for your feedback.
Form temporarily unavailable. Please try again or contact to submit your comments.

Avoid joins in queries

Log in to subscribe to topics and get notified when content changes.

Avoid joins in queries

SQL joins used to combine tables negatively impact performance.

Use database views instead of joins when you need to query data from multiple tables. Database views perform essentially the same function as joins, while reducing the affect on system performance.

A number of useful database views are installed with the Database Views plugin, and administrators can create new database views.