Mike Matrigali (JIRA) wrote:
I ran this change 20 times and it worked on my laptop, it would always fail a few times out of 20 before the fix. I am not sure why this fix works as the test seems to already create indexes after tables so statistics should already be up to date.
While it is good that we get this noise out of derbyall, it seems like this fix covers up a problem that we do not quite understand. As far as I have understood, it seems like the optimizer due to some timing issues does not use the indexes. I think we should file a JIRA for this problem.
-- Øystein
