Re: db file sequential/scattered read

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Fri, 19 Jan 2001 16:10:41 -0000
Message-ID: <979920481.5497.0.nnrp-14.9e984b29@news.demon.co.uk>

When loading a post with emotional overtones, it is best to get the answer absolutely one hundred per cent accurate.

You can also get 'sequential reads' when doing a full table scan when the next read requires a single Oracle block to be read.

--
Jonathan Lewis
Yet another Oracle-related web site:  http://www.jlcomp.demon.co.uk

Practical Oracle 8i:  Building Efficient Databases

Publishers:  Addison-Wesley
See a first review at:
http://www.ixora.com.au/resources/index.htm#practical_8i
More reviews at: http://www.jlcomp.demon.co.uk/book_rev.html



Ricky Sanchez wrote in message <3A685E5B.1CE3217B_at_home.com>...


>This thread is making me nuts.

 


>                  This applies to b*tree indexes of course. So, if we read

 an


>index as a range scan of key values, we are forced to read the blocks in an

>order that is not physically contiguous on disk. The term "sequential read"

>describes the sequentially logical aspect of this type of index access.

>

Received on Fri Jan 19 2001 - 10:10:41 CST