I have a table with 15 columns and 15000 rows of data, however, whenever I try to query it it takes about 10 minutes to return a result. I am assuming that this has to do with the NVarchar(max) column. Is there anyway to speed up the performance of this query?
asked Mar 17 at 04:00 PM in Default
David 2 1
I don't have access to the table right now as it's an issue I noticed the other day on a clients estate. However, the statistics are up to date and there is a clustered index on the ID column. There are no covering indexes. What I'm really asking is if I create a nonclustered index like below then would it improve performance for the client. I don't have access to test this at present.
Or would a Full-Text index work better?
Edit--- Thinking through the issue I believe I may have come up with a solution. The NVarchar(max) column basically stores pdf's internally in the database. If I turn turn on FILESTREAM and move the pdf's out of the table onto the file system the query performance will improve?