i would like to know how can i fine tune the following query since the cost of the query is too high ..
insert into temp temp_1 select a,b,c,d from xxxx
.. database used is IDS..
From what I've found out, IDS isn't a database, but a gateway to present different databases in an independent way.
What I'd check first is the real cost associated by using an explain on the DML to check for bottlenecks. If the problem is a costly scan on an column, index that column. If it's the combination of multiple columns, index those.
But if it's really just the query as you wrote it, I don't really see much to optimize on the query itself. The problem might be with the transfer speed between tables, or a costly index / trigger on the target table.