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


Subject
Views
Written By
Posted
9048
May 16, 2007 02:31AM
3521
May 17, 2007 05:07AM
Re: datetime vs date,time
3038
May 17, 2007 06:08AM
2931
May 17, 2007 10: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.