Subject RE: [firebird-support] RE: Unecessary reads when update referenced table ?
Author Evelyne Girard

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