Hey Tim, all On Wed, Jun 24, 2009 at 10:03 AM, Little, Timothy<tlit...@thomaspublishing.com> wrote: > Why, you might ask, index on physmessage_id? Because then the db won't > have to do a fetch on items from the table since it's in the INDEX > itself, saving any unnecessary reads. FYI: That only holds true for InnoDB, not for MyISAM.
cheers, -- Walter Heck, Engineer @ Open Query (http://openquery.com) Affordable Training and ProActive Support for MySQL & related technologies Follow our blog at http://openquery.com/blog/ OurDelta: free enhanced builds for MySQL @ http://ourdelta.org -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org