Chat now with support
Chat with Support

SQL Optimizer for SAP ASE 3.8 - User Guide

Introduction Tutorials Preferences Editor Functions SQL Information and Functions Performance Monitor SQL Inspector SQL Collector for Monitor Server SQL Scanner Index Advisor SQL Optimizer
SQL Optimizer Overview Optimization Engine Common Coding Errors in SQL Statements What Function Should l Use to Retrieve the Run Time? Unsatisfactory Performance Results SQL Optimizer Functions SQL Editor Optimized SQL Activity Log
SQL Worksheet SQL Formatter Database Explorer Code Finder Object Extractor SQL Repository Index Impact Analyzer Index Usage Analyzer Configuration Analyzer Migration Analyzer Abstract Plan Manager User-Defined Temp Tables SQL History Legal Information

User-Defined Temp Tables Tutorial

Tutorials > User-Defined Temp Tables Tutorial

When your SQL statement uses a temporary table, you must create a temporary table before you use the SQL statement in several modules. When you exit from the program or connect to another session, all the temporary tables you created are dropped.

Create Temporary Tables 

  1. Click image\B_UserDefinedTempTable.gif.

  2. On the Creation tab, type in the statements for creating the temp table. You may include CREATE, SELECT INTO, INSERT, UPDATE and DELETE statements.

  3. Click Execute.

 

Related Topic

User-Defined Temp Tables Overview

SQL History Tutorial

Tutorials > SQL History Tutorial

Throughout the use of the product, SQL statements are saved in the SQL History so that you can use them again. They are stored in a file so that they are available even if you exit the program.

Find Previously Used SQL Statements

  1. Click image\B_SQLHistory.gif.

  2. To lookup SQL statements, enter the text string to search for in the SQL Text field. You can specify if you want to search in the last connection or last action. In the Last Action field, select an action from the drop down field. Only actions that have occurred in the present session will be available.

  3. Select the SQL statement and click one of the buttons in the window to copy the SQL statement to another module.

 

Related Topic

SQL History Overview

Preferences

Preferences Overview

Preferences > Preferences Overview

Preferences allow the alteration of the default settings used in several of the modules.

To open the Preferences window

Click image\B_Preferences.gif.

When you change the settings, your latest settings are always saved and restored each time to exit and restart the program. You can also save several sets of preference settings either by saving settings from one or more tab pages or by saving all the preference settings.

To save specific settings so that you can use them later

  1. Select the Preferences settings.

  2. Click Save.

  3. Enter a filename for the saved settings. Click Save.

  4. From the Save Preferences Profile window, select the tab pages for the setting you want to save. Click OK.

To restore the saved settings

  1. In the Preferences window, click Load.

  2. In the Open File window, select the filename.

  3. Click Open.

 

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating