Sivaraman,
download IB_SQL from www.ibobjects.com, use the Cursor page sheet and
prepare your query. Then you'll get the plan.

Set

At 05:56 09.06.2003 +0000, you wrote:

>We are using IBOQuery component.Query.open takes this much of time.I
>checked all the properties of the query.Everything is o.k.