select
/*+index( b HR_EXAM_PAPER_PER_HIS_IDX)*/ ---括号内写的是表的索引名称
b.PKID,
(CASE
WHEN b.ANSWER = b.RIGHT_ANSWERS THEN
'Y'
ELSE
'N'
END) IF_RIGHT
from Hr_Exam_Paper_Per_His_145 b
ORDER BY b.PKID;
/*+index( b HR_EXAM_PAPER_PER_HIS_IDX)*/ ---括号内写的是表的索引名称
b.PKID,
(CASE
WHEN b.ANSWER = b.RIGHT_ANSWERS THEN
'Y'
ELSE
'N'
END) IF_RIGHT
from Hr_Exam_Paper_Per_His_145 b
ORDER BY b.PKID;