oracle pq distribute,Oracle Hints - 先知的提示

SQL_FEATUREDESCRIPTION

------------------------------------------------------- --------------------------------------------------

ALLA Universal Feature

ANSI_REARCHANSI rearcihtecture

COMPILATIONSQL COMPILATION

CBO SQL Cost Based Optimization

ACCESS_PATHQuery access path

AND_EQUALIndex and-equal access path

BITMAP_TREEBitmap tree access path

FULLFull table scan

INDEXIndex

INDEX_ASCIndex (ascending)

INDEX_COMBINECombine index for bitmap access

INDEX_DESCUse index (descending)

INDEX_FFSIndex fast full scan

INDEX_JOINIndex join

INDEX_RS_ASCIndex range scan

INDEX_RS_DESCIndex range scan descending

INDEX_SSIndex skip scan

INDEX_SS_ASCIndex skip scan ascending

INDEX_SS_DESCIndex skip scan descending

SORT_ELIMSort Elimination Via Index

ADAPTIVE_PLANAdaptive plans

AUTO_REOPTAutomatic reoptimization

PERF_FEEDBACKPerformance feedback

STATS_FEEDBACKStatistics feedback

BUSHY_JOINbushy join

CBQTCost Based Query Transformation

CBQT_OR_EXPANSIONCost Based OR Expansion

CVMComplex View Merging

DIST_PLCMTDistinct Placement

JOINFAC Join Factorization

JPPDJoin Predicate Push Down

PLACE_GROUP_BYGroup-By Placement

PULL_PREDpull predicates

STAR_TRANSStar Transformation

TABLE_LOOKUP_BY_NLTable Lookup By Nested Loop

TABLE_EXPANSION Table Expansion

UNNESTunnest query block

VECTOR_AGGVector Transformation

CURSOR_SHARINGCursor sharing

DMLDML

JOIN_METHODJoin methods

USE_CUBECube join

USE_HASHHash join

USE_MERGESort-merge join

USE_MERGE_CARTESIANMerge join cartesian

USE_NLNested-loop join

USE_NL_WITH_INDEXNested-loop index join

JOIN_ORDERJoin order

OPT_MODEOptimizer mode

ALL_ROWSAll rows (optimizer mode)

CHOOSEChoose (optimizer mode)

FIRST_ROWSFirst rows (optimizer mode)

OR_EXPAND OR expansion

OUTLINEOutlines

PARTIAL_JOINPartial Join Evaluation

PARTITION Partition

PQParallel Query

PARALLELParallel table

PQ_DISTRIBUTEPQ Distribution method

PQ_MAPPQ slave mapper

PQ_REPLICATEPQ replicate small tables

PX_JOIN_FILTERBloom filtering for joins

STAR_TRANSStar Transformation

TABLE_LOOKUP_BY_NLTable Lookup By Nested Loop

STATSOptimizer statistics

CARDINALITYCardinality computation

COLUMN_STATSBasic column statistics

CPU_COSTINGCPU costing

DBMS_STATSStatistics gathered by DBMS_STATS

DYNAMIC_SAMPLINGDynamic sampling

DYNAMIC_SAMPLING_EST_CDNEstimate CDN using dynamic sampling

GATHER_PLAN_STATISTICSGather plan statistics

INDEX_STATSBasic index statistics

OPT_ESTIMATEOptimizer estimates

TABLE_STATSBasic table statistics

DATA_SECURITY_REWRITEXS Data Security Rewrite

QUERY_REWRITEquery rewrite with materialized views

RBO SQL Rule Based Optimization

SQL_CODE_GENERATORSQL Code Generator

SQL_MANAGEMENT_BASE SQL Management base

SQL_PLAN_MANAGEMENT SQL Plan Management

TRANSFORMATIONQuery Transformation

CBQTCost Based Query Transformation

CBQT_OR_EXPANSIONCost Based OR Expansion

CVMComplex View Merging

DIST_PLCMTDistinct Placement

JOINFAC Join Factorization

JPPDJoin Predicate Push Down

PLACE_GROUP_BYGroup-By Placement

PULL_PREDpull predicates

STAR_TRANSStar Transformation

TABLE_LOOKUP_BY_NLTable Lookup By Nested Loop

TABLE_EXPANSION Table Expansion

UNNESTunnest query block

VECTOR_AGGVector Transformation

CLUSTER_BY_ROWIDCluster By Rowid Transformation

GROUPING_SET_XFORMGrouping Set Transformation

HEURISTIC Heuristic Query Transformation

CNTCount(col) to count(*)

COALESCE_SQcoalesce subqueries

CSECommon Sub-Expression Elimination

CVMComplex View Merging

DECORRELATEView Decorrelation

ELIMINATE_SQeliminate subqueries

FILTER_PUSH_PREDPush filter predicates

FULL_OUTER_JOIN_TO_OUTERJoin Conversion

GBYELGroup-by Elimination

JPPDJoin Predicate Push Down

OBYEOrder-by Elimination

OLD_PUSH_PREDOld push predicate algorithm (pre-10.1.0.3)

OUTER_JOIN_TO_ANTIJoin Conversion

OUTER_JOIN_TO_INNERJoin Conversion

PRED_MOVE_AROUNDPredicate move around

SET_TO_JOINTransform set operations to joins

SVMSimple View Merging

TABLE_ELIMTable Elimination

UNNESTunnest query block

USE_CONCATOr-optimization

XML_REWRITE XML Rewrite

CHECK_ACL_REWRITE Check ACL Rewrite

COST_XML_QUERY_REWRITECost Based XML Query Rewrite

XMLINDEX_REWRITEXMLIndex Rewrite

ZONEMAPZone Maps

DDLDDL

EXECUTIONSQL EXECUTION

STATS_ONLOADStatistics on load

VECTOR_PROC Vector Processing

WINDOW_CONSOLIDATOR WINDOW CONSOLIDATOR