MySQL Forums
Forum List  »  MyISAM

Re: Impact on indexes while renaming tables
Posted by: Jacky Shu
Date: November 30, 2005 03:56PM

Manoj Yadav wrote:
> I'm trying to load data into a temp table and then
> renaming in to the original table name to keep the
> down time to a minimum but I do not think the
> table is being indexed properly after I rename it.
>
> Can someone suggest what is the best method to to
> do such a process or what I might be doing wrong?
>
> Thanks.

i guess that you used CREATE TABLE ...SELECT statement, it won't create index like CREATE TABLE LIKE.
best method to build a index? I don't know whether ALTER TABLE is best or not.

Jacky Shu

OCPDBA, MCDBA

Options: ReplyQuote


Subject
Views
Written By
Posted
3288
November 30, 2005 11:17AM
Re: Impact on indexes while renaming tables
2200
November 30, 2005 03:56PM


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.