The recording table is the largest table in the database, unsuprinsingly it takes significantly longer to build this index than any other. Look at use of temporary tables and other ideas to improve this.