I have 10 years of development experience in .net technologies. Additionally I have strong databases experience.
I can look into your issue quickly. However, can you please confirm if you want the optimization at ASP.net or database end. Moreover, please confirm which database you are using?
I look forward to hearing from you.