Oracle FAQ

Your Portal to the Oracle Knowledge Grid

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US

Home -> Community -> Usenet -> c.d.o.server -> Re: Horrible Query Performance, Simple Query -- Performance Tuning Help Needed

Re: Horrible Query Performance, Simple Query -- Performance Tuning Help Needed

From: onedbguru <onedbguru_at_firstdbasource.com>
Date: 19 Apr 2006 10:13:10 -0700
Message-ID: <1145466790.028098.278500@i39g2000cwa.googlegroups.com>

what indexes do you have on these tables? While tkprof is useful - an explain plan would be more useful. Received on Wed Apr 19 2006 - 12:13:10 CDT

This message: [ Message body ]
Next message: Brian Peasland: "Re: Pct Free, Pct Used."
Previous message: Brian Peasland: "Re: Backup en Caliente"
In reply to: WhiteDog: "Horrible Query Performance, Simple Query -- Performance Tuning Help Needed"
Next in thread: stevedhoward_at_gmail.com: "Re: Horrible Query Performance, Simple Query -- Performance Tuning Help Needed"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US