Thanks Evgenij! One last question: Does it have a cost involved for creating a Linked Table? Like $ value per call Redirected to Target Table?
On Thursday, October 29, 2020 at 10:10:24 AM UTC-4 Evgenij Ryazanov wrote: > Hello. > > >> 1. How does Linked Table work? >> > It simply redirects all queries and data modification commands to the > target database. > > >> When i create a Linked Table in H2 Database - does it continuously >> monitor the actual database table that it is linked to - for changes? >> > No. > > >> and if changes are identified does it deletes all records and insert them >> again or does it updates only new /or updated entry? >> > They aren't detected, but all your attempts to do something with a linked > table are passed to the target database and it will obliviously know the > current data in the table, because it its own real table. > > >> 2. What performance impact it would have on original database table? >> > It depends on performance of calls into target database and complexity of > your queries. H2 tires to read information about indexes from the target > database to optimize complex queries better, but in some cases execution > plan may be far from being perfect, optimizer of H2 is not very advanced. > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to h2-database+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/fa705fa7-c799-4bc8-9cdd-1f7356871203n%40googlegroups.com.
