Subject Re: [firebird-support] Re: Violation of UNIQUE KEY constraint during UPDATE
Author Milan Babuskov
Ann W. Harrison wrote:
> The PK search is quick

Generally, yes. But in this case it has to be done for *each* record.
AFAIU, that means that it has to locate each record. A simple "natural"
update also touches all records, but it doesn't even bother with index
so it should be quicker. Right?

--
Milan Babuskov
http://fbexport.sourceforge.net