-
Difference between Full scan and Fast full scan?
Dear all, I read the below link.
http://www.lc.leidenuniv.nl/awcourse...3/optimops.htm
Here is what understood.
Fast full index scan
Fast full scan is used when all the columns in query is existing in index segment. It reads the entire index by using multiblock reads and can be parallelizd.
My question is what is the difference between full scan and fast full index scan? My understanding is, full index scan is same as fast full index scan. Only diffence is, index full scan does not use muliblock read count. Is this correct? Am i missing any other point here??
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|