Re: Self Join Performance

2006-07-12 Thread Brent Baisley
uot; <[EMAIL PROTECTED]> To: Sent: Tuesday, July 11, 2006 9:50 PM Subject: Self Join Performance Hello everyone! I've got a few questions regarding optimizing self-joins. So I've got these three tables: mysql> describe FieldName; +-++--+-+---

Self Join Performance

2006-07-11 Thread Andrew Wood
Hello everyone! I've got a few questions regarding optimizing self-joins. So I've got these three tables: mysql> describe FieldName; +-++--+-+-++ | Field | Type | Null | Key | Default | Extra | +-+--