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 - source

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



Inserting 3 lac records into a table

Updated June 15, 2018 07:06 AM


Expensive Insert Operation pause Other Insert Operation

Updated September 19, 2017 06:06 AM

How to handle HUGE 16GB SQL file?

Updated January 26, 2019 12:06 PM