Re: Improve performance on below query.

"James Williams" <techsup_at_mindspring.com> wrote in message news:39a3deb3.7977368_at_news.mindspring.com...
> Below is a query I need to get to perform better. It is using a lot of
> resources during fetch. ky_so_no on both tables has an index. Any
> hints!
>
> select count(*)
> from
> woa.serv_ord where ky_so_no not in ( select ky_so_no from
> woa.so_fld_ord_rao)

Try this:
SELECT count('1') FROM woa.serv_ord o
 WHERE NOT EXISTS (SELECT '1' FROM woa.so_fld_ord_rao i

                                        WHERE o.ky_so_no=i.ky_so_no);