query optimization

[vssp]

Hi friends

Thanks for your help to solve my previous issue .

This is the same problem i have alreay send for you. I hope you are send me any idea.

I am using INDEX key to optimize the query . That time in my database 75000 records only but now more then 150000 records so i need again optimize the query. If any idea please send me how to solve the issue .


Thanks
vssp

[chazzy]

use another index. what does your query look like and what does the index definition look like?