Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2009
    Posts
    1

    Unanswered: How to know my query is the optimized one.

    Hi all,

    I just want to know how we can ensure our query is the optimized one ? Any way to optimize the querry by ourselves .

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    The best way to know if a query is performing well is to examine the number of row read to the number of rows selected. The larger the ratio, the worse the query is performing. Who better to optimize the query than the person who knows the system the best.


    Andy

Posting Permissions

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