DB-NEMEC.COM

Database and Data Warehouse Solutions

Some Useful References on Metalink

Gathering Statistics

Metalink Note	114671.1 Gathering Statistics for the Cost Based Optimizer 130899.1 How to Set User-Defined Statistics Instead of RDBMS Statistics 122009.1 How to Retrieve Statistics Generated by ANALYZE SQL Statement 130688.1 Report Statistics for a Table, it's columns and it's indexes with DBMS_STATS 130911.1 How to Determine if Dictionary Statistics are RDBMS-Generated or User-Defined 102334.1 How to automate ANALYZE TABLE when changes occur on tables 1074354.6 DBMS_STATS.CREATE_STAT_TABLE: What Do Table Columns Mean? 117203.1 How to Use DBMS_STATS to Move Statistics to a Different Database 149560.1 Collect and Display System Statistics (CPU and IO) for CBO usage 153761.1 Scaling the system to improve CBO optimizer	Wolfgang Breitling's Choice
Metalink Note 175258.1	http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocu....	How to Compute Statistics on Partitioned Tables and Indexes
Note:236935.1	Global statistics - An Explanation	definitions and example

CBO Generall

Metalink Note 35934.1	Cost Based Optimizer - Common Misconceptions and Issues	Some common used traps in CBO (based in 7.x with some updates)
Metalink Note 41954.1	Hash Join	Algorithm used for (inner, noparallel) hash join
Metalink Note 92202.1	stored outline	How to manipulate stored outline to fit required plan
Metalink Note 29236.1	SQL Statement HINTS	List of optimizer hints
More on Hints	<Note:50607.1> How to specify an index hint <Note:62364.1> Hints and subqueries <Note:69992.1> Why is my hint ignored? <Note:68084.1> Using hints to optimize an Update with subquery not using index on updated table
Metalink Note 14736.1, 116447.1	outer join outer join killer	a.x=b.x(+) and b.y(+) = 5 explained

Partitioning

UKOUG 2004

Gorman, T., Scaling the DW to Infinity

Partitionwise Publishing,

Start transformation,

Partition pruning, table compression

Metalink Note

179518.1

Partition Pruning and Joins

Integrity

Metalink

DISABLE VALIDATE explained

don't speak english?