Re: Help! Long data types

The IN clause is real slow and inefficient. Use an outer join instead.

SELECT COUNT(*)
FROM tmp_poheader,

            poheader
WHERE (tmp_poheader.ponum=poheader.ponum(+)) AND

              (poheader.ponum IS NULL)

Arthur Merar wrote:

> Hello,
>
> Actually I have two questions.
>
> First, what is it with these long data types? Why can't I do anything
> with them? I need to compare to fields called NOTES in two different
> tables.....the NOTES field is of LONG data type.....how can I do this?
> I keep getting errors......
>
> Also, I run this query:
>
> select count(*) from TMP_POHEADER where
> ponum NOT IN (select ponum from POHEADER);
>
> That is a simple query right? There are even indexes on the PONUM
> field. Why then after 3 hours do I not get any results? There are
> only 30,000 records in the tables.....
>
> Any help would be appreciated....
>
> Thanks,
>
> Arthur
> amerar_at_unsu.com
Received on Fri Mar 19 1999 - 07:35:37 CST