Hi sivram

Sunday, June 8, 2003, 2:46:20 PM, you wrote:

s> Is there any document available in the net regarding "optimize the
s> query" and "Index".
A really good starting point I found was to download a copy of
INTERBASE PLANalyzer it is a small app that will show you what is
going on with a query. It also comes with a lot of good help which
gives you a good idea as to what you can do to optimize things.

Andy