heh i had a similar style problem, i think it was more 1000x than 200x, but its because certain query structures the optimizer couldn't figure out, had to try l

heh i had a similar style problem, i think it was more 1000x than 200x, but its because certain query structures the optimizer couldn't figure out, had to try like 4 different re-writes of the sql till the optimizer could understand it. I guess at this point I just see it as just part of my job to do this insane stuff, good to know that others see this as hard :)