Joining the temp table with dblink will decrease the performance of the query?
Printable View
Joining the temp table with dblink will decrease the performance of the query?
Joining the temp table with dblink will decrease the performance of the query?
My scenario is presently i am creating tables dynamically and storing the records in the tables.I am using dblinks to get the data from other tables.
So now i want to change the procedures to use temp tables instead of dynamically creating and storing.
So my only concern is the performance.Because i saw somewhere, joining the temp tables with the dblink tables will decrease the performance.
If this is yes can someone let me know what exactly happens when i use temp tables instead of dynamically creating them.
It would be helpful if someone respond to this immediately,because this is very urgent for me.
DBLinks are a poor performing feature - avoid if possible.
You create a "temp" table - Oracle creates a temp table for you; pretty much the same thing.
Want to be sure? test it.
Hi , thanks for the reply.
But my question is "previously i used dynamically generated tables(not temporary tables).Now i want to use temporary tables instead of using dynamically created tables.
In some situations i may need to join the temporary table with dblink tables.
So if i join temporary table with dblink will that cause the performance problem.
If yes, then how?
mmhh... I see. Let me clarify it.
"DBLinks are a poor performing feature - avoid if possible.
You create a "temp" table - Oracle creates a temp table for you; pretty much the same thing.
Want to be sure? test it."
You access dblink tables through network, its ought to be slower, whether you join it with temporary or permanent table. Why don't you first get the dblink tables locally and then perform whatever you feel like?
Not always the case, dblinked instance could be hosted in the same box.Quote:
Originally Posted by gtcol
Either way dblink would perform poorly no matter what.