On Thu, Aug 2, 2018 at 10:34 AM Keith Medcalf <kmedc...@dessus.com> wrote:
> > Yes. Look at the CREATE TABLE for table A (completely ignore table B as > it serves no purpose whatsoever).... > Rah, silly me... I assumed A.aid referenced B.id. Why have a B table at all then. > Also, if you create an index on the child key as is required for > performance, there is no "slowdown" whatsoever.... Of course. Something I always do in Oracle, index all my FK columns... Silly me again. Boy, not my morning :). Thanks for setting me straight Keith. --DD _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users