Yes. The records that end with '9' take more time every time.

And the attachment is the execution plans(.sqlplan).

Thanks.

In addition,the records ending with 'z' also take more time than other records.

I am now in Japan and the SQLServer's language is Japanese and my english is not good enough to translate the execution plans exactly.

You can create a table to do...

To GilaMonster:

It should take a same time for all the records when using NVARCHAR.

But now the records ending with '9' take much more time than the non-9 records.

This is the...

To tung:

The table is created as follows:

CREATE TABLE T_JUMIN_B_TBL (

MANAGEMENT_NO CHAR(8) NOT NULL,

PERSONAL_NO VARCHAR(8) NOT NULL,

FAMILY_NAME NVARCHAR(50) NULL,

FAMILY_NAME_Y NVARCHAR(50) NULL,

...

...

MODDATE DATETIME NULL) ON 'KFS_DATA'

GO

ALTER TABLE T_JUMIN_B_TBL

ADD CONSTRAINT T_JUMIN_B_TBL_PK PRIMARY...

It was because of the coding fault at the beginning

and now I want to know why this phenomenon happened.