performance on Query


  • I created a view with 10 tables. one of the table has name (nvarchar(200)) , alias name, and notes (nvarchar(max)). when my view select the above 3 field, the reads of query hits 10 time more, if I select other column UID, integer column of the same table, the reads of the query is not increase. why the reads are increased 10 time when my query select the column nvarchar data type.

    I tried with varchar also. I faced the same problem.


    Monday, August 05, 2013 4:57 AM


All replies