Just an update, adding the index that SSMS suggested cut the runtime of the query from ~26 minutes to 3 seconds. Thank you for opening my eyes to the Execution...

Thank you! So there shouldn't be an issue changing the data type of the columns on my end with importing the data of the Varchar(max) type that we receive from...

The Database I'm working on is a replication of the database within the third party application that my company uses to conduct business. I'm sure they set up the tables...

Upon a quick google I think I should be looking for a Tasks entry on the right click menu, however I don't see that as an option when I right...

Jeff, which ones are VARCHAR(MAX)? Are those the fields with length -1?

Awesome! Thank you Jonathan I will try that! Do I modify my query to use the newly created IX_DocumentLog_1 or would I keep it the same?

So the plan looks the same, however I get the Missing Index when I change it to top 10k.

And here is the DDL (I think)

Here is the full Query I need to run. I am also attaching the execution plan for the full query, I will look into if there is a functional difference...

It doesn't look like there are indexes on either of those columns, I'll look into that! How would that effect the data currently in the table?

The Table has just under 2 million rows (1958393), and takes 32:08 to fully query every row and column. Does SQL go through the table line by line and cross...

As far as Data Types being Returned, just strings of varying lengths and the Date-timestamp, which is why I am surprised at the length of time required to execute this.

I do not think any of the data fields would be LOBS, There are just a massive amount of rows in the full DocumentLog table. Last week I ran the...