t;
> regards
> DeRyl
>
>
> - Original Message -
> From: <[EMAIL PROTECTED]>
> To: "DeRyl" <[EMAIL PROTECTED]>
> Cc: <[EMAIL PROTECTED]>
> Sent: Tuesday, October 26, 2004 6:17 PM
> Subject: Re: question about indexes
&
Sent: Tuesday, October 26, 2004 6:17 PM
Subject: Re: question about indexes
You asked about indexes for these tables
I would make "dictionaryid" the PK of each dictionary_tbl.
I would add an index to each dictionary_tbl for dictionaryword.
I would make the PK for dict_client_tbl (clie
You asked about indexes for these tables
I would make "dictionaryid" the PK of each dictionary_tbl.
I would add an index to each dictionary_tbl for dictionaryword.
I would make the PK for dict_client_tbl (clientid, dictionaryid)
You also asked about fastest possible searches.
Whenever you hav