How to improve the efficiency of TSYS resource features

Http://www.tsov.net/blog/article.asp? Id = 416
TSYS resources are stored in the numeric type. Therefore, it is troublesome to update files and change the type to the numeric type directly, which is convenient and more efficient.
For example:
Original method:
SQL = "select Top 5 Title, FilePath, SmallImg, batch content, AddTime From view_NewsInfo where Class = 61 and Instr (',' + Speciality + ', 29 ,') <> 0 order By Id DESC"

The Speciality model in the database is Numeric. The default value is 0,
SQL = "select Top 5 Title, FilePath, SmallImg, limit content, AddTime From view_NewsInfo where Class = 61 and Speciality = 29 order By Id DESC"

At the same time,
... Where Class = 61 and Speciality = 29 ....
And
... Where Speciality = 29 and Class = 61 ....
The execution efficiency is also different,
The former queries all the content features before querying the features.
The former is more efficient than the latter.

In addition:
Supplement:
Modify
'Speciality = Replace (Request ("Speciality"), "", "") This is the original
Speciality = Request ("Speciality ")