hello, I have a main table called client_tbl which contains:
clientid bigint(14) [primary key] zoneid smallint(2) [secondary key] clientame varchar(255) clientaddress clientemail clientwww clientinfo clientamount decimal(6,1) and a lot of dictionaries that are int he same schema - so I describe them just like that: dictionary_tbl: dictionaryid int dictionaryword varchar(32) and dict_client_tbl: clientid dictionaryid all questions I use are just like that select c.* from dictionary_tbl d, dict_client_tbl k, client_tbl c where d.dictionary like 'some_eord_part%' and d.dictionaryid=k.dictionarytbl and k.clientid=c.clientid order by c.clientamount desc, c.clientname asc [! it is required sort order] there can be a few combinantions with more than one dictionaries my questions are: 1. how should be a good set of indexess on these tables [search speed is a primary requirement]? 2. how to optimize search speed? client table contains about 1200000 records disctionaries from 300 to 250000 records what can I write more to better problem describe? regards DeRyl -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]