Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB SQL » View Thread |
Messages 1 to 3 of 3 total |
Find records without a link in another table - fast |
Thu, Aug 24 2006 6:28 PM | Permanent Link |
"Ralf Mimoun" | 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 |
Thu, Aug 24 2006 7:17 PM | Permanent Link |
Michael Baytalsky | > 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 |
Fri, Aug 25 2006 4:56 AM | Permanent Link |
"Ralf Mimoun" | 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 |
This web page was last updated on Friday, May 3, 2024 at 08:07 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |