Re: SQL Query help

From: BEDick <bdick_at_cox.net>
Date: Wed, 13 Mar 2002 18:33:47 GMT
Message-ID: <fYMj8.14592$E_3.1307242@news2.east.cox.net>

"markag" <member_at_dbforums.com> wrote in message news:3c8e6f7d$1_2_at_spamkiller.newsgroups.com...

> SELECT PEM.ENC_ID FROM PEM.ENC_ID WHERE PEM.ENC_ID = PES.ENC_ID AND
> PEM.ENC_ID = PP.ENC_ID(+) AND PP.ENC_ID Is NULL AND PEM.GRP_ID = 500

Except for the FROM, which I assume is a typo, the query looks good. Have you indexed ENC_ID in the PP and PES tables? Have you ANALYZED the tables?

--
Later,
BEDick

Received on Wed Mar 13 2002 - 12:33:47 CST