Re: multiblock read count

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Mon, 18 Sep 2000 13:56:55 +0100
Message-ID: <8q53f1$7me$1@soap.pipex.net>

"Mark D Powell" <markp7832_at_my-deja.com> wrote in message news:8pqjpf$kqj$1_at_nnrp1.deja.com...
> Multi-block read count only comes into effect for full table scans (and
> maybe fast full index scans). In the past it has been recommended to
> set this parameter equal to the OS maximum number of bytes that can be
> read in one IO request which is usually 64K or 128K on most UNIX
> systems

Is the equivalent setting for NT4/Win2k noted anywhere?

regards

--
Niall Litchfield
Oracle DBA
Audit Commission UK

Received on Mon Sep 18 2000 - 07:56:55 CDT