This question is locked. New answers and comments are not allowed.
I am having an interesting issue with a view.
We have a table (order) that has a large number of foreign keys and we connect them all together in a view (order_detail).
If we save changes to the order then query the order_detail view we cant see the updated record in the view until we evict the order_detail record from the L2 cache.
Thanks in advance for any help,
Ryan
We have a table (order) that has a large number of foreign keys and we connect them all together in a view (order_detail).
If we save changes to the order then query the order_detail view we cant see the updated record in the view until we evict the order_detail record from the L2 cache.
Thanks in advance for any help,
Ryan