Nach Ordnungsbegriffen durchsuchen

SQL Profiles in the Data Dictionary
19 August 08 09:40 | Striving for Optimal Performance

In the paper SQL Profiles (page 22) I described the data dictionary tables where the hints belonging to SQL profiles are stored. For example, with the following query it is possible to display the hints associate to the SQL profile named opt_estimate...

Abgelegt unter: 11gR1, 10gR2, 10gR1, Query Optimizer

Operation CONNECT BY WITH FILTERING
17 Juni 08 11:09 | Striving for Optimal Performance

It happened to me several times to being asked about the mysterious full table scan in CONNECT BY operations. In this post I would like to share with you some of the information I wrote about it in my book (pages 233 to 236) . The operation CONNECT BY...

Abgelegt unter: TOP, Execution Plan, 11gR1, 10gR2, 10gR1