Paradox Community

Items in pnews.paradox-client_server

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


Copyright © 2004 thedbcommunity.com