The difference between index fast full scan and index full scan in Oracle

Source: Internet
Author: User

When the index full scan is made, Oracle navigates to the root block of the index, then to the branch block (if any), then navigates to the first leaf block and then reads it according to the Leaf block's doubly linked list order. The blocks it reads are sequential and sorted.
The index fast full scan is different from the beginning of the segment, reading the containing bitmap block, root block, all the branch block, leaf block, the order of reading is entirely determined by the physical storage location, and take a number of blocks read, each read db_file_ A multiblock_read_count.
So:
1. Index full scan to sort, index fast full scan is not sorted (the index full scan will be returned according to the leaf block sort, and the index fast full scan is returned in the order of storage blocks in the index segment).
2. The index full scan must not read the index segment header, and the index fast full scan to read the index segment header.

The difference between index fast full scan and index full scan in Oracle

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.