Explore why a simple SELECT COUNT(*) FROM TABLE; query in MySQL can be excessively slow or surprisingly fast, and gain insights into the factors that influence query performance.