Subject | NON-Indexed Reads |
---|---|
Author | Todd Brasseur |
Post date | 2001-07-10T21:09:33Z |
I am confused!!!
I have a table (PROPERTYHEADER) with a PRIMARY KEY (PROPID).
When I do:
update propertyheader
set globalupdate = '01/01/2001'
where propid = 30022225;
Statistics show:
PLAN (PROPERTYHEADER INDEX (RDB$PRIMARY59))
PROPERTYHEADER INDEXED READS 1
PROPERTYHEADER NON-INDEXED READS 26283 (one for every record)
Why am I getting so many NON-INDEXED READS????
It looks like it is using my Primary Key based on the Plan!!!
I have a table (PROPERTYHEADER) with a PRIMARY KEY (PROPID).
When I do:
update propertyheader
set globalupdate = '01/01/2001'
where propid = 30022225;
Statistics show:
PLAN (PROPERTYHEADER INDEX (RDB$PRIMARY59))
PROPERTYHEADER INDEXED READS 1
PROPERTYHEADER NON-INDEXED READS 26283 (one for every record)
Why am I getting so many NON-INDEXED READS????
It looks like it is using my Primary Key based on the Plan!!!