Kenneth

Are ALL of your search fields optimized?

Kev

>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