SoberDude Posted August 13, 2009 Share Posted August 13, 2009 Whenever I attempt to add or delete an index with a very large table (about 4 million rows), it keeps loading for hours. After it is finally complete, it tells me that the cardinality of that specific row is 0. If the cardinality is 0, I'm assuming the index is useless. So, my question is: is there are a way to speed up index-adding/delete on large tables? Quote Link to comment https://forums.phpfreaks.com/topic/170145-indexing-large-tables/ Share on other sites More sharing options...
fenway Posted August 21, 2009 Share Posted August 21, 2009 That's quick strange... even after ANALYZE? Quote Link to comment https://forums.phpfreaks.com/topic/170145-indexing-large-tables/#findComment-903185 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.