>It's not the first field in the index, so I don't think it >will use it
>for searching on "WHERE field5 = 'xxx' ". >Try adding an index on field5 only > CREATE UNIQUE INDEX main_indexf5 ON main (field5); >I don't see any problem. Thanks Jay. You are right. The query in a PC change from 34 Secs to 0,036 secs. Nice. Thanks for your suggestions. China. --------------------------------------------------------------- Scegli il tuo dominio preferito e attiva la tua email! Da oggi l'eMail di superEva e' ancora piu' veloce e ricca di funzioni! http://webmail.supereva.it/new/ ---------------------------------------------------------------