We are running attached report daily on a server:
SQL server 2005, 32 bit, SP3 12 CPU and 16 GB RAM.
MAXDOP setting 1.
As per query plan i can assume for thr key look up that i need to create the index to include those missing columns, but the problem is it says to include a column which is ntext.
i tried removing that column from the script but seems no luck.
I.e index 21 which shows a key look up , missing index script shows to include the columns listed there, but column 4 being ntext, I am unable to do so.
This missing index is the one with most beneficial improving query cost per sp_blitzindex
Please help on how i can tune this, thanks
By SQLDB 60 asked Mar 31, 2015 at 10:31 AM
To add that column as an include, you would need to change the underlying column data type from the (deprecated)
There are many things that could (and probably should) be improved first. The one that stands out is this:
The 580 rows from the Index Seek on
By SQLkiwi ♦ 6.6k answered Mar 31, 2015 at 12:15 PM