Subject: | Re: Can someone answer this?
| Date: | Sun, 15 May 2016 09:45:24 -0400
| From: | "Larry DiGiovanni" <nospam@nospam>
| Newsgroups: | pnews.paradox-client_server
|
Liz McGuire wrote:
> You will need to index the FK, also, you can actually set up a foreign
> key, which will like the tables, create constraints, and should speed
> things up (but won't break things like in Paradox, unless you actually
> need to break the FK rules).
The above comment reads (to me) that I can either create an index OR create
a foreign key constraint. Just to clarify, if an index on the FK column is
required, you must explicitly create that index. The foreign key constraint
does not do this automatically.
--
Larry DiGiovanni
|