Is there a way that we can figure out what the cost of a SQL query is via jdbc ? any command etc?
Printable View
Is there a way that we can figure out what the cost of a SQL query is via jdbc ? any command etc?
whether is ODBC or JDBC it is going to hit the SQL server. See the cost (use Execution plan) in query analyser and see the cost and the query plan.
COmplete cost can be analysed depending on the architecture. if you have a 3-tier architecture on the same box, cost will be less but not advisable.