A table with 80% text data type and 140 columns taking much time in table scan which slow down the query RRS feed

  • Question

  • I have a table with 120 columns where 90 perent columns are nvarchar(max) data type and there is no way to change this data type. This table contains almost 30lacs records , so when I am selecting all the columns it takes too much titme to show recordset. In this circumstance , I was interested to change this table as a colum store table but column store does not support nvarchar(max) data type and now I am finding the way how can i redesing this table which will help to make query fast.

    Note I have tried with non clustered indexing by different column which has also not impacted making query fast.

    Any help will be appriciated

    Tuesday, September 24, 2019 1:26 PM

All replies