OraFAQ Forum: Performance Tuning » From where can I get all available SQL tuning HINTS for Oracle?

Home » RDBMS Server » Performance Tuning » From where can I get all available SQL tuning HINTS for Oracle?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

From where can I get all available SQL tuning HINTS for Oracle? [message #176541]

Thu, 08 June 2006 12:57

mburukimethu
Messages: 1
Registered: June 2006
Location: Columbus, Ohio

Junior Member

I have seen listings of current hinsts for Oracle 9i/10g from your website and other sources.
But if I wanted to check it myself from the Database or current $ORACLE_HOME, how do I proceed?

strings $ORACLE_HOME/bin/oracle |grep hints > somefile.txt appears to give something but not a whole lot.

Your help is very much appreciated. Thanks.

Report message to a moderator

Re: From where can I get all available SQL tuning HINTS for Oracle? [message #176543 is a reply to message #176541]

Thu, 08 June 2006 13:03

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

when all else fails, RTFM
http://download-west.oracle.com/docs/cd/B19306_01/server.102/b14200/index.htm#H

hints, 9.2

ALL_ROWS, 2.6.4.1
APPEND, 2.6.4.2
CACHE, 2.6.4.3
CLUSTER, 2.6.4.4
CURSOR_SHARING_EXACT, 2.6.4.5
DRIVING_SITE, 2.6.4.6
DYNAMIC_SAMPLING, 2.6.4.7
FACT, 2.6.4.8
FIRST_ROWS(n), 2.6.4.9
FULL, 2.6.4.10
HASH, 2.6.4.11
in SQL statements, 2.6.3
INDEX, 2.6.4.12
INDEX_ASC, 2.6.4.13
INDEX_COMBINE, 2.6.4.14
INDEX_DESC, 2.6.4.15
INDEX_FFS, 2.6.4.16
INDEX_JOIN, 2.6.4.17
INDEX_SS, 2.6.4.18
INDEX_SS_ASC, 2.6.4.19
INDEX_SS_DESC, 2.6.4.20
LEADING, 2.6.4.21
location syntax, 2.6.3
MERGE, 2.6.4.22
MODEL_MIN_ANALYSIS, 2.6.4.23
NO_EXPAND, 2.6.4.26
NO_FACT, 2.6.4.27
NO_INDEX, 2.6.4.28
NO_INDEX_FFS, 2.6.4.29
NO_INDEX_SS, 2.6.4.30
NO_MERGE, 2.6.4.31
NO_PARALLEL, 2.6.4.32
NO_PARALLEL_INDEX, 2.6.4.34
NO_PUSH_PRED, 2.6.4.36
NO_PUSH_SUBQ, 2.6.4.37
NO_PX_JOIN_FILTER, 2.6.4.38
NO_QUERY_TRANSFORMATION, 2.6.4.41
NO_REWRITE, 2.6.4.39
NO_STAR_TRANSFORMATION, 2.6.4.42
NO_UNNEST, 2.6.4.43
NO_USE_HASH, 2.6.4.44
NO_USE_MERGE, 2.6.4.45
NO_USE_NL, 2.6.4.46
NO_XML_QUERY_REWRITE, 2.6.4.47
NOAPPEND, 2.6.4.24
NOCACHE, 2.6.4.25
NOPARALLEL, 2.6.4.32
NOPARALLEL_INDEX, 2.6.4.34
NOREWRITE, 2.6.4.39
ORDERED, 2.6.4.48
PARALLEL, 2.6.4.49
PARALLEL_INDEX, 2.6.4.50
passing to the optimizer, 19
PQ_DISTRIBUTE, 2.6.4.51
PUSH_PRED, 2.6.4.52
PUSH_SUBQ, 2.6.4.53
PX_JOIN_FILTER, 2.6.4.54
QB_NAME, 2.6.4.55
REWRITE, 2.6.4.56
RULE, 2.6.4.57
specifying a query block, 2.6.3
STAR_TRANSFORMATION, 2.6.4.58
syntax, 2.6.3
UNNEST, 2.6.4.59
USE_CONCAT, 2.6.4.60
USE_HASH, 2.6.4.61
USE_MERGE, 2.6.4.62
USE_NL, 2.6.4.63
USE_NL_WITH_INDEX, 2.6.4.64

Report message to a moderator

Previous Topic:	Require Information
Next Topic:	Advice

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 16 00:47:13 CDT 2024