Subject | Re: [firebird-support] Re: Violation of UNIQUE KEY constraint during UPDATE |
---|---|
Author | Milan Babuskov |
Post date | 2005-08-05T18:29:16Z |
Ann W. Harrison wrote:
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
> The PK search is quickGenerally, 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