none
performance on Query

    Question

  • 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.


    Developer

    Monday, August 05, 2013 4:57 AM

Answers

All replies