MySQL Forums
Forum List  »  General

Re: Performing table inserts/selects while a alter-table query is running?
Posted by: Bobby k
Date: May 13, 2010 09:21PM

Yeah, I was thinking I would migrate it exactly how you said it. Again, appreciate the advise up till now, it will be used.

On a similar note, while we are on the subject of table optimization, after looking into table partitions.. I realized if I could make a partition for every SID (there is only a few thousand of those), this would optimize the selects on that table by a TON(at least it seems like it would?). Is this possible, only reason I ask, is because, every example I have found defines in-line partitions with a set number, and not some variable number of them?

Thanks

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.