Hi,

I'm trying to make a searchform where Ithe user can serach for a customer on muliple fields at the same time (fields are phonenumber, name, adresse, zipcode...)

If I make a select statement with all these fields in it - the query takes up to 30 seconds og at table with 350000 records. How can I optimize this searchtime ?


Regards,

Kenneth Ingebrigtsen