Re: This is a very slow query. Any ideas?

From: Noodles <noodles_at_aol.com>
Date: 1997/06/26
Message-ID: <19970626013600.VAA21744@ladder01.news.aol.com>#1/1

Have you tried running the query through EXPLAIN ? That should indicate how Oracle is parsing and optimizing your query. If you have the cost-based optimizer turned on, make sure you've run analyze to update all of the data dictionaries with good statistical data.

Cliff
(cbuetikofer_at_isinet.com)

#include StandardDisclaimer Received on Thu Jun 26 1997 - 00:00:00 CDT

This message: [ Message body ]
Next message: Bas Ven: "ANSI + ProC ???"
Previous message: Tom Waterhouse: "This is a very slow query. Any ideas?"
In reply to: Tom Waterhouse: "This is a very slow query. Any ideas?"

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