Re: IO Bottleneck won't go away

From: Peter Hiemenz <PeterHiemenz_at_compuserve.com>
Date: Sun, 31 Oct 1999 20:11:38 +0100
Message-ID: <VA.0000005e.32bffd74@hp>

In article <7vc7nn$ia2$1_at_autumn.news.rcn.net>, Alan Shein wrote:
> I had one query that was taking 12 _hours_
> to run with multiple outer joins. When I split it up, it reduced the time to
> 6 _minutes_!
>

Hi,

did you try using the INDEX(<table> hint?

I just noticed some larger performance gains when using INDEX(<table>) hint in which <table> is the main table every row needs to be read joining other tables with outer joins.

Explain plan (TOAD) was similiar (by head, syntatically wrong):

sort
  nested outer
    nested outer
      nested outer
   <table> access index
..

Peter Hiemenz
Hilden near Dusseldorf

HMS Planung & Automation GmbH, Duisburg, Germany

mailto:Peter.Hiemenz_at_t-online.de
mailto:PeterHiemenz_at_compuserve.com Received on Sun Oct 31 1999 - 13:11:38 CST