Hello, I have a query that will be used alot on my website that involves a 42 million record table being self-joined. The primary table instance will be limited by an index resulting in 1 to about 50,000 rows being selected, then joined to the second instance of the table, which will retrieve one to five or so rows for each record in the source table. This table is totally static and is updated once per day during a maintenance cycle.
Here's my question: Does it make sense (from a performance standpoint) to actually make a duplicate of this table so MySQL is joining two identical tables rather than self joining the same table? Thanks, -Hank __________________________________ Do you Yahoo!? Free Pop-Up Blocker - Get it now http://companion.yahoo.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
