Oracle FAQ

Your Portal to the Oracle Knowledge Grid

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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Query too slow ... control execution order with optimizer hints?

Re: Query too slow ... control execution order with optimizer hints?

From: Greg <gforestieri_at_yahoo.com>
Date: 19 Dec 2002 14:16:39 -0800
Message-ID: <f1923f6a.0212191416.5c08dc2d@posting.google.com>

Indexes?

Looks like you *might* be doing a full table scan x times, then also doing sum x times. What does explain plan look like and what are you trying to accomplish in a business sense? Received on Thu Dec 19 2002 - 16:16:39 CST

This message: [ Message body ]
Next message: Greg: "Re: Database Reporting"
Previous message: Bruce Loth: "Re: Using InterConnect to push data from one Oracle DB to another"
In reply to: Chris Neubauer: "Query too slow ... control execution order with optimizer hints?"

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