Hi all,

strange to ask a DBISAM question in a ElevateDB newsgroup - but dbisam.sql
is gone

I have a table, say Articles. I want to list all articles without an order.
So I write:

SELECT A.ID
FROM Articles A
LEFT OUTER JOIN Orders O ON O.ArticleID = A.ID
WHERE O.ID IS NULL

Pretty simple stuff - except that it needs ages to complete. There are about
20k Article records and about 200k Orders records. Any idea hwo I can speed
that up?

Ralf

> strange to ask a DBISAM question in a ElevateDB newsgroup - but
> dbisam.sql is gone
No, it's not, you should just update your list of newsgroups.
I can see it, it's called public.dbisam.sql.


Michael

Michael Baytalsky wrote:
....
> No, it's not, you should just update your list of newsgroups.
> I can see it, it's called public.dbisam.sql.

Argh, damn OE! Tahnks, I'll post in the goold old ng.

Ralf