At 09:09 PM 7/10/2001 +0000, Todd Brasseur wrote:

>update propertyheader
> set globalupdate = '01/01/2001'
> where propid = 30022225;
>
>Statistics show:
>...
>PROPERTYHEADER NON-INDEXED READS 26283 (one for every record)
>
>
>Why am I getting so many NON-INDEXED READS????

What are you using to get your statistics?

This is what ISQL gives me:

SQL> update t1 set f1 = 123456 where f1 = 5000
CON> ;

PLAN (T1 INDEX (RDB$PRIMARY8))
Current memory = 9204724
Delta memory = 17408
Max memory = 9436340
Elapsed time= 0.28 sec
Buffers = 2048
Reads = 10
Writes 0
Fetches = 340

Translating loosely, 10 reads and 340 fetches don't add up to
10000 non-indexed reads.


Regards,

Ann
www.ibphoenix.com
We have answers.