MySQL Forums
Forum List  »  Partitioning

Re: Partitioning not working need primary key?
Posted by: newbie Shai
Date: November 01, 2012 10:55AM

Dear Rick,
I got one question regarding indexes. You said make all three as primary key rite first outletID,receiptID,dateTime. So what if I need to search based on date time will this beneficial indexing or I must create a separate index just on datetime?

Options: ReplyQuote

Written By
Re: Partitioning not working need primary key?
November 01, 2012 10:55AM

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.