Is there a way to increase the speed of the following insert without having to create an unclusterd index being suggested by sql server?

by croxfade   Last Updated October 18, 2019 20:06 PM

Below is a query that we are running that takes a while to run. Table 1 has about 400+ million records with 80 columns (this is a db warehouse table). The index being suggested is on the columnx with include all the remaining columns, something that I do not want to do.

select
   *
  into table2
  from
   table1
  where
   table1.columnx = 'value'


Related Questions


Updated May 10, 2017 11:06 AM

Updated June 15, 2018 07:06 AM

Updated September 07, 2017 06:06 AM

Updated September 19, 2017 06:06 AM

Updated January 26, 2019 12:06 PM