Just put indexes on all of your fields that will be searched on.

But, to optimize them, you need to make sure that the SELECT statement matches the indexes.

For example, if you have :

SELECT * FROM MyTable WHERE UPPER(Field1) = lcValue

Ensure that the index expression on Field1 is "UPPER(Field1)", not just "Field1", they need to match exactly.

Let me know if you still have problems.

Kev

>How do I optimize them? I don not have much experience with this.
>
>
>Kenneth