Synthesizing a Row Number Column for Efficient UNION Queries in MySQL

Using Triggers to Dynamically Update Statistics Table in MySQL