I have a stored procedure that uses a sql script that contains a table that has over 20 million rows of data. Processing of this sql script takes longer than it should.
What is the best way to deal with LARGER ROW tables to help reduce SPROC Processing times?
I've tried to pull only a specific date range ( last 2 years, ie. getdate() - 720 ) from this table, but it still takes a long time to pull the data into the temp table.
What the best techniques to use?