I am such a MySQL newb in spite of administering my own databases for 15+ years. Today I had a startling insight into the merit of indexing when an update I canceled after running for 30 minutes completed 0.3 seconds after spending 1 second building an index.🌈