Help on self join and to improve performance issues
621729Feb 6 2008 — edited Feb 7 2008Hi All,
I am new to this group.
When I try to do a self-join for 10 million records it's taking 15 miniutes.Can we reduce the time by using any other tuning techniques?
We tried on using indexes and it's giving same cost as w/out Indexes also.
Please let me know how to use the Indexes in more optimistic way, so that the cost of query will be reduced.
My main target is to reduce the fetching time and reduce the cost amount of execution.Please let us know abt the performance tuning techniques.
Any inputs regards this will be highly appreciated.
Regards,
Jags