Hi all,
I have a master table and slave table, both in the same schema. Whenever the data in the master table is inserted/updated, a respective entry in slave table needs to be inserted/updated. Data is updated/inserted in the master table very frequently and so in the slave table. Both are huge tables with millions of data.
What are possible ways and what is the best way(in terms of performance).
I see, triggers/creating scheduler jobs as ways. Jobs though have the con of not having live data in the slave table.
What is the performance issue with triggers?
Is there any better way?
As scenario 2: If the master and slave table are in different schemas/databases(connected through dblink), which might be the better way?
Thanks in advance.
Sail