At 01:19 PM 1/25/2001 -0800, Ryan Wahle wrote:
>Send the results of the EXPLAIN
table type possible_keys key key_len ref rows Extra
ArgumentCalendar ALL Date [none] [none] [none] 63 where used
CaseID ALL PRIMARY [none] [none] [none] 19701 where used
Parties eq_ref PRIMARY PRIMARY 4 CaseID.CASEID
Send the results of the EXPLAIN
On 25 Jan 2001 15:15:35 -0500, Brian Hughes wrote:
> Hi. Thanks, I like that syntax, I didn't know I could put STRAIGHT_JOIN
> there after the SELECT.
>
> But it doesn't get me anything. EXPLAIN still says I am examining all
> 19,701 rows in CaseID: same probl
> One more thing: you might want to increase your key case and sort buffer to
> make it quicker.
>
> Regards,
> Artem
>
> - Original Message -
> From: "Ryan Wahle" <[EMAIL PROTECTED]>
> To: "Brian Hughes" <[EMAIL PROTECTED]>
> Cc: &l
Thanks, but not really. I wish to get all the cases, even when there is no
Blurb in Preview. Your query only grabs cases where the Blurb in Preview
is missing by adding WHERE Preview.CASEID IS NULL. - Brian
- BLH
At 01:00 PM 1/25/2001 -0600, you wrote:
>Does this help?
>
>SELECT
>A
Hi. Thanks, I like that syntax, I didn't know I could put STRAIGHT_JOIN
there after the SELECT.
But it doesn't get me anything. EXPLAIN still says I am examining all
19,701 rows in CaseID: same problem as before.
- BLH
At 10:46 AM 1/25/2001 -0800, you wrote:
>Try this one:
>
>SELECT STRA
Does this help?
SELECT
ArgumentCalendar.Docket
, ArgumentCalendar.Date
, DATE_FORMAT(ArgumentCalendar.Date, '%W, %M %e, %Y') AS formatted_date
, CaseID.CASEID
, CONCAT(Party1, ' v. ', Party2) AS name
, Blurb
FROM
ArgumentCalendar
, CaseID
, Part
Try this one:
SELECT STRAIGHT_JOIN ArgumentCalendar.Docket
, ArgumentCalendar.Date
, DATE_FORMAT(ArgumentCalendar.Date, '%W, %M %e, %Y') AS formatted_date
, CaseID.CASEID
, CONCAT(Party1, ' v. ', Party2) AS name
, Blurb
FROM ArgumentCalendar
, CaseID
, Parties
LEFT JOIN Preview ON Preview.CASEID