SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQL Performance Help

3292Nov 1 2005 — edited Nov 1 2005

We have a performance difference for a select query in two development environments. ( Same version :Oracle Database 10g Enterprise Edition Release 10.1.0.4.0 ). One query takes 30 seconds in one environment while execution time in other environment is about 5 minutes. Did an explain plan major difference in output shows INDEX FAST FULL SCAN (30 seconds execution time) while other shows TABLE ACCESS FULL(5 minutes execution time). Same index exist in all tables involved in the query. DBA says all system parameters are same in both environments and request development team to identify the cause. Load on both environments are pretty much same. There is room for improvement in the query. But we are trying to find out what causes the performance degradation in one environment.
Can someone help me with some clues to identify the source of this problem ?
Thanks
Deepak

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 29 2005

Added on Nov 1 2005

4 comments

298 views