SQL Optimizer for SAP ASE 3.8 - Release Notes

User-Defined Temp Table Overview

The technique of creating temporary tables to extract data from permanent tables is often used. Because the existent of the local temp table is session related, you need to create these temporary tables in your current session. The User-Defined Temp Table window allows you to create temp tables to use so that you may optimize and analyze SQL statements that use temporary tables. Besides temporary table that you create using the User-Defined Temp Table window, temporary table may also be created during the scanning by the SQL Scanner and during the optimization process by the SQL Optimizer.

Note: Temporary Tables created in the User-Defined Temp Table module are not available in the SQL Worksheet module since a new database session is used to execute commands in the SQL Worksheet.

Related Topics

Create Temporary Tables

Parameters in Temporary Table SQL

View SQL scripts of temporary tables

Drop Temporary Tables

Example of Temporary Tables in SQL Scanner

Copy SQL with Temporary Tables to SQL Optimizer

Create Alternative SQL Which Uses Temporary Tables

Preference Settings for Handling Temporary Tables