0 - 2 of 2 tags for effective

Can some one please tell me, between Volatile table and view, which is better in terms of efficiency, accessbility and use?
What is the difference between them??
Also, can I create a volatile table with same name but using different user ID?

Want to batch sync among the four databases. Which software can be more effective ? Can you give me any idea?