70 761 querying data with transact sql

Label: 1AlterPROCEDUREP_resource_info_select_by_classification_id_and_keyword2 @classification_id INT, 3 @keyword NVARCHAR( -) 4 as 5 BEGIN 6 SELECT * fromT_resource_infoWHERE 7(',' +Ri_classifications+ ',') like '%,' + LTRIM(RTRIM(STR(@classification_id)))+ ',%' 8 and(CONVERT(VARCHAR(MAX), Ri_author) like '%' + @keyword + '%' ORRi_title_cn like '%' + @keyword + '%') 9 END Ten GO One A EXECP_resource_info_select_by_classification_id_and_keyword the,'a '

Label:The previous few days found that the system became very slow, in the profiler found some SQL executed for a few 10 seconds to return the results, then the SQL is as follows:As you can see, the subquery is used in 652 rows, and the number of records in the target table (QS_WIP) is 100000000 +, which can be obtained by the following SQL:SELECT ROWS from sysindexes WHERE id=object_id (' Qs_wip ') and ind

Tags: End processing automatic page tis resultmap char ati hereTotal query data:resulttype= "Java.lang.Integer"> WARNING-@mbggenerated This element was automatically generated by MyBatis Generator, DoNot modify. -select COUNT (id) from Tb_userifTest= "Username! = NULL" >and username like'%${username,jdbctype=varchar}% ' if> ifTest= "Start_time! = null" >and Addtimegt;= #{start_time,jdbctype=TIMESTAMP}if> ifTest= "End_time! = null" >and AddtimeTIMESTAMP}if> Paging query:resultmap= "Baseresultmap"