The triggers only modify current record on update. I’m not 100% sure it is the dependant tables that the indexed reads do read … but it seemed a semi-logical explanation since my update does a natural scan … if this weird behavior is only happening in my databases I will try to find some time to make a test database with minimum data so it could be reproduced by anyone …. Or I maybe will find what is wrong with my databases.
Thank you, Evelyne De : hv...@users.sourceforge.net [mailto:hv...@users.sourceforge.net] Envoyé : 23 octobre 2013 03:40 À : firebird-support@yahoogroups.com Objet : [firebird-support] RE: Unecessary reads when update referenced table ? Firebird itself doesn't access dependent tables if FK value was not changed by UPDATE statement. Do you have UPDATE triggers ? Regards, Vlad