On Sun, 8 Jun 2003 10:24:21 +0000 (UTC), sivram_mail wrote:

> This is my query.
> ...
> how to improve the performance of this query???

Any particular database (IB/Fb)? Which version ?
Windows/Linux/whatever (and version) ?
View/table definitions ? (At least, the interesting parts)
Any other indexes ?
How many records are involved ?
What is the PLAN?
Any other pertinent info ...


--
Aage J.