That's three times as fast as the second example. However, the dynamic SQL is still at a disadvantage. The execute immediate still does its parse, but it uses SQL sharing to resolve the statement.

Scott Stephens creates a package that allows you to clone most database objects with dynamic SQL.

SQL Server 2016, the next major release of Microsoft’s flagship database and analytics platform (which is available as a Community Technology Preview [CTP] as of this writing), includes exciting ...