New to MySQL
Posted by: Ed Shaw
Date: September 02, 2021 03:40PM

Hello all. This may be a dumb question. But with 10+ years of MS SQL experience, I am at a loss of how this works.

If I want to rebuild an index on MySQL, I have some questions:

1. Is this even necessary?
2. What statement should I use?
a. I see "Optimize table <tablename>;" (but this threw an error "Table does not support optimize, doing recreate + analyze instead")
b. Reindex doesn't work (won't run at all).
c. Alter table (a bit nervous to use this one).

Again, sorry for the dumb question, but just trying to translate what I know from MS SQL into MySQL language. :)

Thanks.

Options: ReplyQuote


Subject
Written By
Posted
New to MySQL
September 02, 2021 03:40PM
September 02, 2021 03:57PM
September 02, 2021 04:00PM
September 02, 2021 08:34PM


Sorry, only registered users may post in this forum.

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.