November 2008 Archives

Oracle Optimizer and default row counts

| No Comments | No TrackBacks
This article is basically looking at using multiple values in bind variables but it strikes upon an interesting point regarding the CBO. There are situations where the optimizer assumes a value of 8168 rows simply as a good guess.