I have a transaction table where I am storing buy/sell transactions related information, and this information I am getting is from MQ as an XML and I am also storing XML String as VARCHAR(MAX) in SQL Server database.
The issue is that since I am storing XML String into this table, select query is running very slow.
Is there any way I can increase the performance? Any recommendation will be highly appreciated.
The solution which I can think of is to create another table of 1 -1 mapping with my transaction table to store XML String but not really sure if this is the best idea.