Re: question about indexes

2004-10-26 Thread SGreen
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 &

Re: question about indexes

2004-10-26 Thread DeRyl
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

Re: question about indexes

2004-10-26 Thread SGreen
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