Results 1 to 2 of 2

Thread: Cost of a SQL query

  1. #1
    Join Date
    Jan 2003
    Posts
    58

    Cost of a SQL query

    Is there a way that we can figure out what the cost of a SQL query is via jdbc ? any command etc?

  2. #2
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •