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? 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? Link to comment https://forums.phpfreaks.com/topic/170145-indexing-large-tables/#findComment-903185 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.