I have written the below query to find whether the question is answered by using EXISTS. I need answered value true/false and also want to fine tune this query so that it checks for first occurrence in answer table and get the value as true/false, instead of running through the thousands of value in answer table.

SELECT *
FROM QUESTIONS A
WHERE EXISTS (SELECT *
FROM ANSWERS B
WHERE A.QUESTION_ID = B.QUESTION_ID);