Most efficient query?

[dmonti]

Hi, I am trying to find out if records exist in a file. I am looking for the query with the best performance. Which of the below queries will yield the best performance? SELECT COUNT(*) FROM MYLIB.MYFILE WHERE FIELD2 = 'TEST' SELECT FIELD1 FROM MYLIB.MYFILE WHERE FIELD2 = 'TEST' FETCH FIRST 1 ROWS ONLY SELECT * FROM SYSIBM.SYSDUMMY1 WHERE EXISTS(SELECT FIELD1 FROM MYLIB.MYFILE WHERE FIELD2 = 'TEST' ) Thanks