Subject | RE: [firebird-support] RE: Unecessary reads when update referenced table ? |
---|---|
Author | Evelyne Girard |
Post date | 2013-10-23T12:51:01Z |
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 : hvlad@... [mailto:hvlad@...]
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