Most efficient query? (1 viewing) (1) Guest
Favoured: 0
|
|
|
TOPIC: Most efficient query?
|
dmonti (User)
Fresh Boarder
Posts: 9
|
|
Most efficient query? 8 Months ago
|
Karma: 0
|
|
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
|
|
|
|
|
|
|
The administrator has disabled public write access.
|
|
|
