Re: Temp table question

Roger,  

  The "normal tables" have a heavy footprint which you know of course so I don't have to point out the details of read conisitency and recoverablity involved with redo logging and transaction management of rollback segments. There is no need for this overhead if the information is disposible and only one user is manipulating the data. As you said a earlier in this thread,

>>One of their main benefits is that run like greased lightening

This is at odds with your last reponse which suggests using "normal tables" instead of temporay tables.

From you response, I get the impression that you missed my point. I'm addressing the functionality of creating information that is only changeable by one user and is disposible thus no need for the transactional complexity of involved in rollback segments or disk write obligation of generating redo. The idea is basically a scratch pad, the contents or access or ownership of which could be given to another session.

The complexity involved in this functionality is much simpler that the with "normal tables".

Best
Kyle Hailey    Received on Sat Mar 03 2001 - 08:12:16 CST