YES, I like your proposal to take the CTE table declaration similar to a "CREATE TABLE" statement to include the index declarations.
YES, I like your proposal to take the CTE table declaration similar to a "CREATE TABLE" statement to include the index declarations.