MySQL Forums
Forum List  »  Optimizer & Parser

Re: Creating an index to include ORDER BY
Posted by: Angus
Date: November 03, 2006 09:24AM

And make it unique, right? What about NumberColumn? Shouldn't I be including that? When I tried yours the explain gave the key_len as 8. I get the feeling that only involves the DateColumn part, and not the ThePrimaryKeyColumn which is a 32-bit unsigned int.

Options: ReplyQuote


Subject
Views
Written By
Posted
3209
November 02, 2006 08:28AM
Re: Creating an index to include ORDER BY
2064
November 03, 2006 09:24AM


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.