Actually this is incorrect. A joint key will use one index , not two,

On 16/10/06 18:51, "Daniel Stenning" <[EMAIL PROTECTED]> wrote:

>  Sometimes, in order to avoid the
> performance hit of joint keys, developers will create a single text column
> holding a concatenation of two other columns such as surname+postcode.  This
> is done to use a single index as opposed to two.


_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>

Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>

Reply via email to