I am indexing one table using jdbc plugin query and using timestamp column to check for any update and insert but now, I have to import multiple tables from db.
What would be the efficient way:-
- I used the sql join query in jdbc plugin? Is it going to be able to check for update in all the tables(i have timestamp column in every table).
2: I should make multiple indices for all the tables and run a script for every table to index?
What would be the best way and if any other suggestions?