MySQL Forums
Forum List  »  Optimizer & Parser

Re: datetime vs date,time
Posted by: KimSeong Loh
Date: May 17, 2007 06:08AM

Date is 3 bytes.
Time is 3 bytes.
Datetime is 8 bytes.

The smaller size could have reduce the disk io and the amount of memory required to do sorting.

Did you wrongly use order by field2,field2 desc? field2 twice?

Options: ReplyQuote

Written By
May 16, 2007 02:31AM
May 17, 2007 05:07AM
Re: datetime vs date,time
May 17, 2007 06:08AM

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.