(Resending because my other send didn't get a CC to the list)
From: "Jim C. Nasby" <[EMAIL PROTECTED]>
To: "Cstdenis" <[EMAIL PROTECTED]>
Cc:
Sent: Monday, May 22, 2006 8:20 AM
Subject: Re: [PERFORM] How can I make this query faster (resend)
> On Fri, Ma
cost variables could be adjusted to
better reflect my server's hardware?
- Original Message -
From: "Markus Schaber" <[EMAIL PROTECTED]>
To: "Cstdenis" <[EMAIL PROTECTED]>
Cc:
Sent: Monday, May 22, 2006 8:30 AM
Subject: Re: [PERFORM] How can I make
From: "Jim C. Nasby" <[EMAIL PROTECTED]>
To: "Cstdenis" <[EMAIL PROTECTED]>
Cc:
Sent: Monday, May 22, 2006 8:20 AM
Subject: Re: [PERFORM] How can I make this query faster (resend)
> On Fri, May 19, 2006 at 03:56:49PM -0700, Cstdenis wrote:
> > (Its bee
(Its been a hour and I dont see my message on the
list so I'm sending it again. I've moved the queries and analyze out of the
email incase it was rejected because too long)
query: http://pastebin.ca/57218
In the pictures table all the ratings have a shared index
CREATE INDEX idx_rating O
