Don't load the entire table and don't load all of the tables.
Only pull data you need, nothing more.
Toby, I think Machireddy may be referring to the amount of time it takes to populate the table list itself (so one can choose which tables to join).
Machireddy - how many tables are in this particular Oracle Schema? I'm guessing there are a lot. If so, when Tableau asks for that list of tables, it can take some time for the list to come back.
Thanks for your response
Russell : In that Schema total 18306 tables are der, that is oracle apps schema.
If 18,306 tables need to be returned, I suspect it’ll take a while. While I’m not a particularly big fan of using Custom SQL, consider:
· Using Custom SQL so you don’t have to get in and out of the “tables” dialog multiple times as you JOIN tables together
· Use a view which encapsulates the same information above – this way, you only have to pay the “waiting price” once – to pick the view.