On Fri, 2003-10-31 at 12:25, Nitz wrote:
> You were right, the volume of the data changes the optimizer's
> willingness to use indexes.
AFAICS, the optimizer seems to be making exactly the right guesses for
the production data -- i.e. there's no problem/bug.
> Another funny thing though... I ac
Hi Rod,
here is the actual production trace of the problem.
This is a table of mobile network cells and code-names devided into LAC's.
Two test cells to test with are:
test cell id #1: 900 4900035
test cell id #2: 300 5080140
You were right, the volume of the data changes the optimizer's
willingn
> TRACE:
> The original tables are much bigger, so I've tried to simplify things here.
> Please let me know if there is anything that I could help you with.
You can't do that and expect to get reasonable results. The plans will
change with the volume of data.
Send an explain analyze of the true
