Blogs about: Cost Based Optimizer
Featured Blog
A quick overview of diff_table*
10.2.0.4 came with some 11g features, an extended dbms_stats package. I had made some basic demonstraions below. begin dbms_stats.delete_table_stats(ownname => user, tabname => 'T2'); commit; en… more →
Dünyada 10 çeşit insan vardır, binary bilenler ve bilmeyenler
A quick overview of diff_table*
wrote 1 year ago: 10.2.0.4 came with some 11g features, an extended dbms_stats package. I had made some basic demonstr … more →
Parallelism Partitioning CBO issue
— 1 comment
wrote 1 year ago: Parallelism and partitioning are two excellent features of Oracle. What is the relation between CBO … more →
After another workshop of OracleTurk
wrote 1 year ago: I had my 2 presentation this weekend. It was a fantastic book of Lewis, CBO optimizer. I had met pos … more →
Nested Loop / Hash / Merge over Event 10053 trace file
wrote 1 year ago: One of my colleague asked me about how he can write better SQL. Despite he is a java developer, I ap … more →
Version Dependency
wrote 2 years ago: Here’s a very simple query, hinted to follow a particular execution plan. select /*+ ordered u … more →
Histograms and Joins
— 4 comments
wrote 2 years ago: Those of you who have kept up with the corrections and addenda to “Cost Based Oracle” th … more →
Push_Subq
— 8 comments
wrote 2 years ago: Another little warning for those about to upgrade from 9i to 10g. Some hints will change their behav … more →
Using 10053
— 2 comments
wrote 2 years ago: A little while ago I wrote a note about an anomaly that someone was seeing with the index_ss() hint. … more →
Constraints
— 12 comments
wrote 3 years ago: A little while ago I discussed one side-effect of transitive closure and predicate generation. Coinc … more →
chapter 2 - calc_mbrc.sql
— 1 comment
wrote 2 years ago: rem rem Script: calc_mbrc.sql rem Author: Jonathan Lewis rem Dated: March 2002 rem Purpose: Calculat … more →
Bind Peeking
— 12 comments
wrote 3 years ago: I’ve just received an email from someone who had been on my “masterclass”, and he … more →
How many ways ?
— 18 comments
wrote 3 years ago: Have you ever wondered how hard the optimizer has to work to produce an execution plan. Consider a s … more →
Pushing Predicates
— 6 comments
wrote 3 years ago: Tom Kyte once said he wanted me to start a blog so that I could at least warning people about new ar … more →
Table Order
— 8 comments
wrote 3 years ago: Did you know that it is possible for the cost-based optimizer to come up with a different execution … more →
