Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2002
    Posts
    456

    Post Unanswered: General Index Question

    I am playing with some of our older SQL statements and trying to tweak them but little confused by the usage of index. Sometime it uses the index sometime it does not even though columns which are part of the index are part of the sql. So, my question is there are set rule when index will be used and when not. Any link to a document will be highly appreciated.

    dollar

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5

    Re: General Index Question

    Dollar,

    Look here:

    http://www7b.boulder.ibm.com/dmdd/li...kuznetsov.html

    It explains alot.

    Andy

    Originally posted by dollar489
    I am playing with some of our older SQL statements and trying to tweak them but little confused by the usage of index. Sometime it uses the index sometime it does not even though columns which are part of the index are part of the sql. So, my question is there are set rule when index will be used and when not. Any link to a document will be highly appreciated.

    dollar

Posting Permissions

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