>> I have to search for field5 in some DB files (30 or more >>for a total of 50
>> GB of space and 150 M of records ).
>> select * from main where field5= "AABBCCDD";
> Did you put an index on field5?
Yes I use:
CREATE UNIQUE INDEX main_index ON main (field2,field5,field7);
Is a quite complex index used for eliminating duplicates, is it OK?
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/
---------------------------------------------------------------
