Question: what is the difference between index range scan and index full scan?
Answer: The fast full-index scan can be performed in parallel, whereas an index-range scan or full-index scan can be processed only serially. That is, the database can allocate multiple processes to perform a fast full-index scan, but it can use only a single process for traditional index scans.