Click on the advice to get more details.
Non-deterministic GROUP BY
The SQL retrieves columns that are neither in an aggregate function nor the GROUP BY expression, so these values will be non-deterministic in the result.
Rule ID: RES.001
SELECT without WHERE
The SELECT statement has no WHERE clause and could examine many more rows than intended.
Rule ID: CLA.001
Do you need help resolving the problems with this query? Here are some resources:
- If this tool provided bad advice, use the feedback form at left to report a bug.
Please mention your query ID: #PLUQIJmK.
- Ask your friends to look at it
- Paste the link in a forum, such as Percona's performance forums
Percona offers expert MySQL support services to help you optimize and rewrite problematic queries.
You can contact us as follows:
- Sales USA +1-888-316-9775 M-F 8-5 Pacific time
- Sales UK +44-208-133-0309 M-F 8-5 London time