richswww
-
Posts
2 -
Joined
-
Last visited
Never
richswww's Achievements
Newbie (1/5)
0
Reputation
-
So, by "no effect", you mean, the index should still be in place, so no need to drop and recreate them? Rich S.
-
(Possibly) dumb question: Let's say I have table foo with an index called myindex. If I do "RENAME TABLE foo TO bar" ... Will the "myindex" index be attached to the new table "bar", or should I drop the "myindex" index from the foo table and recreate it on the "bar" table after the rename? Thanks, Rich Stephens