In case you have your own slow SQL query, you can optimize it automatically here.
For the query above, the following recommendations will be helpful as part of the SQL tuning process.
You'll find 3 sections below:
CREATE INDEX itemchoicestable_idx_itembankid ON OdeaMainDataBase.dbo.ItemChoicesTable (ItemBankID);
CREATE INDEX studenttesttablefr_idx_studid_examid_itemban_choicei ON StudentTestTablefromRemark (StudID,ExamID,ItemBankID,ChoiceID);
SELECT
OdeaMainDataBase.dbo.ItemChoicesTable.*,
CASE
WHEN EXISTS (SELECT
*
FROM
StudentTestTablefromRemark
WHERE
StudentTestTablefromRemark.StudID = @studId
AND StudentTestTablefromRemark.ExamID = @examId
AND StudentTestTablefromRemark.ItemBankID = @itemBankId
AND StudentTestTablefromRemark.ChoiceID = OdeaMainDataBase.dbo.ItemChoicesTable.ChoiceID) THEN 'True'
ELSE 'False' END AS isAnswered
FROM
OdeaMainDataBase.dbo.ItemChoicesTable
WHERE
OdeaMainDataBase.dbo.ItemChoicesTable.ItemBankID = @itemBankId