Understanding Temporary Database Tables

Programs often use temporary database tables to hold intermediate results. Creating, updating, and deleting temporary tables is a resource consuming task, however, and can slow program performance. SQR provides two alternatives to using temporary database tables:

• Store intermediate results in an SQR array.

• Store intermediate results in a local flat file.

Both techniques can yield a significant performance gain. Use the SQR language to manipulate the data that is stored in an array or a flat file.