|
-
Will joining the temp table with dblinks will decrease the performance?
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|