Sequential and random db reads

In case of batch operations with bulk data fetching, it is desirable to have sequential data access where as in OLTP, db queries are random.

In sequential access, process reads long continuous blocks. Query that does full table scan (FTS), it reads several blocks in single IO operation. This is sequential access.

An indexed sql query uses random access to fulfill single block read.