Results 1 to 1 of 1
  1. #1
    Join Date
    Dec 2012

    Unanswered: understanding retrieval of max() using ASC index


    I have been trying to understand how indexes work and while reading about reverse index scans came across a statement on indexes with No reverse scan support which says, "if say a column SALARY is indexed in ASC order to find a max() the B-Tree index will be traversed from root node till the leftmost node and then the pointer in the leaf node will be used to traverse to the right leaf node so on till the rightmost node is found"

    I am not sure if the above is true, but if it is just wondering why not traverse from the root node to the rightmost node which has the max() value.

    Last edited by zulfi123786; 11-24-13 at 12:14.

Posting Permissions

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