You are using an outdated browser. Please upgrade to the latest version for the best experience.
How do I narrow my search results?

After you submit your search query:

  1. On the Refine Search results page, select one or more categories of products or services from the left sidebar.
  2. Then for a category with search results, click Select to choose your product and release filters, and then click OK.

For search queries that contain multiple words, surround the query with quotes, and then resubmit your query. Example: "database cloud service"

How do I find the documentation for my product or service?

From the home page, click the technology categories for your products or services. If you do not know which category to pick, try the following features:

  • Click the Find a product tab and search for your product or service.
  • Click Browse All Products & Services at the bottom of the home page to view an alphabetical listing of products and services.
  • Apple Safari: Version 6
  • Google Chrome: Version 29 and later
  • Mozilla Firefox: Version 24 and later
  • Microsoft Internet Explorer: Version 9 and later
Results for STAR_TRANSFORMATION_ENABLED


1 to 10 of 10 results.


Database Reference, 12c Release 1 (12.1)

STAR_TRANSFORMATION_ENABLED

1.275 STAR_TRANSFORMATION_ENABLEDProperty Description Parameter type String Syntax STAR_TRANSFORMATION_ENABLED = { FALSE | TRUE … Basic Yes STAR_TRANSFORMATION_ENABLED determines whether a cost-based query transformation will be

Database SQL Language Reference, 12c Release 1 (12.1)

Comments

OPT_PARAM Hint, OPTIMIZER_SECURE_VIEW_MERGING, and STAR_TRANSFORMATION_ENABLED. For example, the following hint sets the … parameter STAR_TRANSFORMATION_ENABLED to TRUE for the statement to which it is added: SELECT … /*+ OPT_PARAM('star_transformation_enabled' 'true') */ * FROM.... Parameter values that are strings are

Database SQL Tuning Guide, 12c Release 1 (12.1)

Query Transformations

Controls for Star TransformationThe STAR_TRANSFORMATION_ENABLED initialization parameter controls star transformations. This … attempt temporary table transformation. See Also: Oracle Database Reference to learn about the STAR_TRANSFORMATION_ENABLED initialization parameter

Database SQL Language Reference, 12c Release 1 (12.1)

Comments

STAR_TRANSFORMATION Hintfor more information on the STAR_TRANSFORMATION_ENABLED initialization parameter.

Database Reference, 12c Release 1 (12.1)

Basic Initialization Parameters

1.2 Basic Initialization ParametersREMOTE_LOGIN_PASSWORDFILE SESSIONS SGA_TARGET SHARED_SERVERS STAR_TRANSFORMATION_ENABLED UNDO_TABLESPACE

Database Reference, 12c Release 1 (12.1)

Modifiable Parameters

1.4.2 Modifiable ParametersSQL_TRACE SQLTUNE_CATEGORY STAR_TRANSFORMATION_ENABLED STATISTICS_LEVEL TEMP_UNDO_ENABLED … SQL_TRACE SQLTUNE_CATEGORY STANDBY_ARCHIVE_DEST STANDBY_FILE_MANAGEMENT STAR_TRANSFORMATION_ENABLED

Database Data Warehousing Guide, 12c Release 1 (12.1)

Data Warehousing Optimizations and Techniques

Using Star Transformationfact table or tables. The initialization parameter STAR_TRANSFORMATION_ENABLED should be set to TRUE

Database SQL Tuning Guide, 12c Release 1 (12.1)

Influencing the Optimizer

About Optimizer Initialization ParametersSTAR_TRANSFORMATION_ENABLED Enables the optimizer to cost a star transformation for star queries (if true

Database Reference, 12c Release 1 (12.1)

Parameters by Functional Category

1.4.1 Parameters by Functional CategoryOPTIMIZER_USE_SQL_PLAN_BASELINES QUERY_REWRITE_ENABLED QUERY_REWRITE_INTEGRITY STAR_TRANSFORMATION_ENABLED Parallel Execution

Database Reference, 12c Release 1 (12.1)

Database Reference - Contents

ContentsSQLTUNE_CATEGORY 1.273 STANDBY_ARCHIVE_DEST 1.274 STANDBY_FILE_MANAGEMENT 1.275 STAR_TRANSFORMATION_ENABLED 1.276