You are here |
nenadnoveljic.com | ||
| | | |
leonotes.wordpress.com
|
|
| | | | ????????transitive closure?Wiki??????????Oracle????????... | |
| | | |
www.bobbydurrettdba.com
|
|
| | | | We have been discussing query tuning at work and I've come back to an example of the Oracle optimizer choosing the wrong plan due to an error in its calculation of the number of rows returned... | |
| | | |
dioncho.wordpress.com
|
|
| | | | One of my colleagues sent following test case, of which he couldn't control the join order with hints. 1. Create objects - table t1, t2 and t3 2. Now Let's set the join order as T1->T2->T3, using global hints convention. But it seems that Oracle does not work as expected. It really seems that the... | |
| | | |
alexzeng.wordpress.com
|
|
| | I am reading Expert Oracle Practices by Oracle Database Administration from the Oak Table. I'd like to summary and share what I learned. This chapter PL/SQL and the CBO by Jo?e Senega?nik is pretty interesting. It tells how to use oracle extensible optimizer to set the selectivity and the cost of PL/SQL functions. This will... |