Adding compound (hash, years) index (or even better unique index if it fits in your business logic) in both tables should speed up things.
-- Alexey Polyakov -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
