[Solved] JDBC Optimisation of query [closed]

Question

JDBC doesn’t optimize database queries. A specific JDBC driver might do query optimization, but it is likely that query optimization is done by the backend database. (Many / most worthwhile optimizations require knowledge of the tables that the JDBC driver does not have.)

Another question what is the difference between analyse and compiling query in JDBC?

Compiling is simply parsing the SQL, resolving identifiers in the SQL source to tables, columns and so on, checking that the types of expressions are correct.

Query optimization starts with the compiled SQL and works out the most efficient way to perform the queries based on things like presence / absence of indexes and sizes of tables.

Accepted Answer

JDBC doesn’t optimize database queries. A specific JDBC driver might do query optimization, but it is likely that query optimization is done by the backend database. (Many / most worthwhile optimizations require knowledge of the tables that the JDBC driver does not have.)

Another question what is the difference between analyse and compiling query in JDBC?

Compiling is simply parsing the SQL, resolving identifiers in the SQL source to tables, columns and so on, checking that the types of expressions are correct.

Query optimization starts with the compiled SQL and works out the most efficient way to perform the queries based on things like presence / absence of indexes and sizes of tables.