On Thu, Oct 21, 2010 at 4:31 PM, Tim Uckun <timuckun@gmail.com> wrote:
> On Fri, Oct 22, 2010 at 4:33 AM, Brian Hirt <bhirt@me.com> wrote:
>>>
>>> There are only two tables in the query.
>>>
>>
>> Tim,
>>
>> No, your query is written incorrectly. I don't understand why you come on to this list all hostile and
confrontational. Regardless, people still try to help you and then you still ignore the advice of people that are
givingyou the solutions to your problems.
>
>
> I don't think I was hostile. I think people were hostile to me as a
> matter of fact.
>
> I asked a question and the first reply was really snarky and unhelpful.
Agreed. But when Tom pointed out the problem in your query you were
quite sure you couldn't be wrong. When I asked you to run explain to
see what kind of row estimate you got, I got no answer. This was a
query problem not a hardware tuning problem.
The best step for getting a good answer is forming a good question.
So, has changing the query made it faster? Did explain show what I
expect, a huge cartesian product? Just guessing.