MySQL Forums
Forum List  »  Newbie

Re: SELF Join using datetime columns, Performance Issues
Posted by: Peter Brawley
Date: February 04, 2014 03:10PM

This would be more efficient with timestamps (4 bytes) than with datetimes (8 bytes). Add that to the list of changes to be made soon.

(A system with dumb DDL like this that doesn't allow you to change the structure needs upgrading or replacement ASAP.)

Have you tried giving the table an index on servicecheck,datetime,status,status_type,prior_status?

What is the result of EXPLAIN EXTENDED on your query (BBCode code tags please)?

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.