Please help optimize this query

[Quimbly]

Hi everyone,
I've been trying to get this query to run quicker. Currently it just takes too long. Does anyone have any suggestions about optimizing it?

SELECT DISTINCT outerquery.name, "group" FROM analog outerquery WHERE EXISTS (SELECT * FROM analog innerquery WHERE innerquery."group" = outerquery."group" AND innerquery.ptnum != outerquery.ptnum AND innerquery.name LIKE 'ZZZ_%') AND uterquery.name LIKE 'ZZZ_%'

 

[PHV]

You may try something like this:
SELECT DISTINCT A.name, A.group FROM analog A INNER JOIN analog B
ON A.group=B.group AND A.ptnum!=B.ptnum
WHERE A.name LIKE 'ZZZ_%' AND B.name LIKE 'ZZZ_%'

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244