Details
-
Type:
Bug
-
Status: CLOSED
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: 2.9.3, 10.7, 11.1
-
Component/s: Tests & Quizzes (Samigo)
-
Labels:
-
11 status:Resolved
-
Conversion Script Required:Yes
-
Previous Issue Keys:SAM-3040
Description
Observed monitoring MySQL slow query logs. Need an index on LABEL and ENTRY
select publisheda0_.*
from SAM_PUBLISHEDASSESSMENT_T publisheda0_
inner join SAM_PUBLISHEDMETADATA_T publishedm1_
where publisheda0_.ID=publishedm1_.ASSESSMENTID and publishedm1_.LABEL='ALIAS'
and publishedm1_.ENTRY='0c7e6eb0-1d8b-448d-8550-f4260aa52b821474912340152';