Re: Full table scan query

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Tue, 22 Jan 2002 18:32:53 +0100
Message-ID: <qg8r4usla6b1qjeoe7kf6pncsq394l68sq@4ax.com>

On Tue, 22 Jan 2002 15:58:47 -0000, Norman Dunbar <Norman.Dunbar_at_lfs.co.uk> wrote:

>PS. I've checked the maximum number of blocks read in a FTS using the
>old event 10046 level 8 trick as recently discussed, and on this server,
>for this database, 25 is the maximum.
>
>------------------------------------------------------------------------
>-----
>Norman Dunbar EMail: Norman.Dunbar_at_LFS.co.uk
>Database/Unix administrator Phone: 0113 289 6265
> Fax: 0113 289 3146
>Lynx Financial Systems Ltd. URL: http://www.Lynx-FS.com
>------------------------------------------------------------------------
>-----

Obviously, in many cases, with this setting a FTS always gonna be cheaper (in terms of numbers of I/Os to issue)

Regards

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Tue Jan 22 2002 - 11:32:53 CST