[GENERAL] SELECT FOR UPDATE with ORDER BY to avoid row-level deadlock?

n before, so there must be something wrong with it... :) Regards, Panther ___ Új év - új állás? Mérnöki, értékesítői, asszisztensi, pénzügyi és IT állások a Jobline.hu-n! http://ad.adverticum.net/b/cl,1,6022,135079,205796/click.prm ---

Re: [GENERAL] "not in" clause too slow?

Ottavio Campana <[EMAIL PROTECTED]> írta: > mytable.id is primary key. > > I create copy_mytable with > create table copy_mytable as (select * from mytable); > > the planer behavior does not change no matter if I create and index > on copy_mytable.id or not. Try this, with an index on copy_myt