Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2011
    Location
    Delhi
    Posts
    24

    Unanswered: Which Index is using by sql statement

    Hi,

    Is there any way to find out that the sql statement I am running on database using which Index to complete the operation. I am using DB2 V9.7 fp3 on linux platform.
    thanks..!!

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    EXPLAIN (or Visual Explain)

    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
  •