MySQL Forums
Forum List  »  Optimizer & Parser

Re: inner join vs left join - huge performance difference
Posted by: michael cook
Date: July 06, 2016 12:29PM

I also don't know that I can add a calculated column for the incremented timestamp - the fact is, in the full query I'm looking for there are several of those "time shifted" columns - and they amount by which they shift can be dynamic, so I can't simply add several calculated columns unless I added a whole bunch for every contingency

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.