Subject | PK vs Index on table scan |
---|---|
Author | Gary Benade |
Post date | 2005-06-15T09:35:08Z |
I have a table customers with a PK on the field LINK, which is unique
select * from customers where link = 'WWW0000010'
the stats say 12123 non-indexed reads were performed during the operation
Is this correct, or in other words, is this the way a PK is used?
The plan says PLAN( CUSTOMERS NATURAL)
The machine takes some strain, so I am almost sure a full table scan is
happening.
Any ideas or explainations would be appreciated.
TIA
Gary
select * from customers where link = 'WWW0000010'
the stats say 12123 non-indexed reads were performed during the operation
Is this correct, or in other words, is this the way a PK is used?
The plan says PLAN( CUSTOMERS NATURAL)
The machine takes some strain, so I am almost sure a full table scan is
happening.
Any ideas or explainations would be appreciated.
TIA
Gary