Before running the analysis define Output options.
-
On Adaptive Histogram, select OUTPUT.
Adaptive Histogram > Output
-
On this screen, select:
- Use the Teradata Explain Feature… — Option to generate a SQL EXPLAIN SELECT statement, which returns a Teradata Execution Plan to the RESULTS tab.
-
Store the tabular output of this analysis in the database — Option to generate a Teradata TABLE or VIEW populated with the results of the analysis. Once enabled, the following three fields must be specified:
- Database Name — Enter the name of the Teradata database where the resultant Table or View will be created. By default, this is the Result Database.
- Output Name — Enter the name of the Teradata Table or View.
- Output Type — Select Table or View. Although a Table is always available, Views can not be specified due to limitations in Teradata.
- Stored Procedure — To request the creation of a stored procedure containing the SQL generated for this analysis, enter the name of the stored procedure. This results in the creation of a stored procedure in your logon database in place of the execution of the SQL generated by the analysis. For more information, see Stored Procedure Support (Teradata Database).
- Procedure Comment — When an optional procedure comment is entered, it is applied to a requested stored procedure with an SQL Comment statement. It can be up to 255 characters in length and contain substitution parameters for the output category (Score, ADS, Stats, or Other), project name and/or analysis name (using the tags <Category>, <Project>, and <Analysis>, respectively). The default value of this field may be set on the Defaults tab of the Preferences dialog, available from the menu.
- Create output table using the FALLBACK keyword — If a table is selected, it will be built with FALLBACK if this option is selected.
- Create output table using the MULTISET keyword — If a table is selected, it will be built as a MULTISET table if this option is selected.
- Advertise Output — The Advertise Output option may be requested when creating a table, view or procedure. This feature “advertises” output by inserting information into one or more of the Advertise Output metadata tables according to the type of analysis and the options selected in the analysis. For more information, see Advertise Output.
- Advertise Note — An advertise note may be specified if desired when the Advertise Output option is selected, or when the Always Advertise option is selected on the Connection Properties dialog bix. It is a free-form text field of up to 30 characters, used to categorize or describe the output.
- Generate the SQL for this analysis, but do not execute it — When selected, the analysis only generate SQL, returning it, and terminating immediately.