Such as title, in addition to the ntext class fields, the speed is normal,

CodePudding user response:

What database?

CodePudding user response:

Is slowly should not use index, estimate you of this field, in the condition of the like, if is fuzzy query, %, both before and after such use is less than the index, will be a full table scan,

CodePudding user response:

The database is SQL server,

CodePudding user response:

Use nvarchar (Max)
Don't use ntext