I was using QuickDesk ....

I also used Marathon to check the statistics and got the same thing.

With Interactive SQL (from IBConsole) I Get:

Execution Time 00:00:01.0430
Prepare Time 00:00:00:0060

Starting Memory 11320320
Current Memory 11352064
Delta Memory 31744
Number of Buffers 2048
Reads 1540
Writes 3
Plan Plan(PropertyHeader INDEX(RDB$PRIMARY59))
Records Fetched 1

The execution time goes down to 00:00:00:0210 the next time I run it
because of cache (I believe).

Could this have anything to do with the fact that I have many, many
foreign key constraints defined? That this is the main table in our
database where several children tables are tied to it with Foreign Keys?

Todd

--- In ib-support@y..., "Ann W. Harrison" <aharrison@i...> wrote:
> 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.