#DateForumTypeThreadPost
230 Aug 2012 @ 08:34 PDTGeneralReplyHow to see the unused indexes for a queryYou can see which indexes were used by looking at the EXPLAIN. To see when an index was last used, you can run the following query. It is not speific to a query. SELECT DatabaseName , Table...
122 Aug 2011 @ 12:42 PDTGeneralReplyDifference between Single Table Join Index, NUSI and Hash Index Just a minor correction. Hash Indexes are not a form of Join Index. They are similar in usage to Single Table Join Indexes, but aggregation, secondary indexing, and triggers are not permitted on ...