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.

No TrackBacks

TrackBack URL: http://www.lewin-planet.net/scgi-bin/mt/mt-tb.cgi/3

Leave a comment