Sql Drop And Recreate Table. Are you dropping those indexes in one step then loading data into your table only to recreate the indexes in a post data load step. By not having the indexes at load time SQL Server can load the data much faster because there are no indexes to update.
DROP is a DDLData Definition Language command and is used to remove table definition and indexes data constraints triggers etc for that table. Performance-wise the DROP command is quick to perform but slower than TRUNCATE because it gives rise to complications. Im a bit late just for reference.
First published on MSDN on Jan 19 2017 As we continue our journey with Temporal Tables the next topic will be how do you drop them.
Performance-wise the DROP command is quick to perform but slower than TRUNCATE because it gives rise to complications. Its not a good practice to drop and recreate physical tables in stored proc of course TSQL will not stop you from doing it in stored procs. Drop and recreate table not an option. Create a temp table via select into drop the old table and recreate the table with the proper datatypes.
