pietlinden (12/14/2016)
Oh, you neglected to mention that it was a vendor database. Key piece of information.having said that, the only way I can think of helping this situation out is to create a table in another database (that you control) and then indexing the columns... and then you'd have to modify the query... if you can't do that, I have no idea how to fix it.
Thanks! once again. It is definitely part of a table that has indexes. However, I am not sure whether these indexes are really helping the cause. I've attached the script for that table and the indexes in question. Please review the same and let me know if possible what would be the best course of action for the same.
Regards,
Fievel