Getting data from mysql multiple tables

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:-

  1. 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?

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.