i've been experimenting with indexes recently. so, i've spending some time going though SQL logs looking for table scans. there are a lot of joins from message to message_flags which result in unnecessary full table scans.
i think that message and message_flags are joined one-to-one. this is inefficient. is there a good design reason why message and message_flags are separated? robert --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
