WL#360: Having a flag for each table to annotate that it is changed
Status: Assigned — Priority: Medium
> Hi! > > Adding a counter in table_list is not a good idea, as we can't easily > access this structure when the table is updated. > > We could however add a flag to the table structure: > > table->updated > > that is set to 1 if the table was updated in this statement. > > (It would of course have to be cleared in 'table-open') > > Sinisa> Then only those tables who get truly updated / deleted would be > Sinisa> invalidated in table cache. > > Yes. > > Regards, > Monty >
Copyright (c) 2000, 2016, Oracle Corporation and/or its affiliates. All rights reserved.