I'd like to set up some indexes that contain some fields in the INCLUDE portion of the index. Being that the fields are NTEXT, they cannot be used. It's an easy change to alter the fields, but I'm wondering if anyone has done this before and ran into any issues?
The particular table I'm looking at is changeitem. We have a lot of queries that reference this table and setting up a better index would reduce the processing time and number of reads.
Here is the index I'm thinking of setting up provided I change OLDVALUE, OLDSTRING, NEWVALUE and NEWSTRING from ntext to nvarchar(max)
CREATE INDEX idx_chgitem_group_field_v2 ON dbo.changeitem (groupid, FIELD)
INCLUDE (FIELDTYPE, OLDVALUE, OLDSTRING, NEWVALUE, NEWSTRING)
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events