If you want to pick the indexes then you need to access the indexed columns in your where clause. Seconly i think it is not picking the indexes because of the LIKE clause.

[Edited by vinit on 11-15-2001 at 06:18 AM]