A common reason for a poorly performant query is because it’s processing more data than required.
Querying unnecessary data demands extra work on the server, adds network overhead, and consumes memory and CPU resources on the application server.
The effect is amplified when the query includes multiple joins.
The rule flags an issue when a SELECT * query is provided as an argument to methods in java.sql.Connection and
java.sql.Statement.
What is the potential impact?
- Performance: the unnecessary extra data being processed brings overhead.
- Sustainability: the extra resources used have a negative impact on the environment.
