Re: Tuning a Query

From: Ronald <devnull_at_ronr.nl>
Date: 21 Nov 2001 05:33:27 -0800
Message-ID: <67ce88e7.0111210533.274f4f5f@posting.google.com>

oraskm_at_yahoo.com (Sanjay Mishra) wrote in message news:<eca56b4a.0111202313.742528f2_at_posting.google.com>...
> I am having difficulty in tuning the following query. It takes more
> than one hour to insert 1.4 million rows.

Is it the query or the insert that consumes most of the time ? If it is the insert, make the table TABLE_O nologging and drop the index. Do the insert using the append hint. This should make quite a difference. Build the index when ready, in parallel to speed the creation up.

Ronald.

---

http://ronr.nl/unix-dba
Ben je een ervaren dba en wil je dat ergens anders laten zien, mail me dan. Received on Wed Nov 21 2001 - 07:33:27 CST