The other week a new production process was running much more slowly than
anticipated. A file needed to be sent out by 6:00pm and at the rate the
table was being populated it wouldn't complete until around 9:30pm. The
production people and developers came to me for help and I saw that the SQL
it's possible that the index was small enough to stay cached in the SGA?
From: Miller, Jay [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Tuning question - Why did this index help so much?
Date: Wed, 25 Jul 2001 08:31:28 -0800
was small enough to stay cached in the SGA?
From: Miller, Jay [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Tuning question - Why did this index help so much?
Date: Wed, 25 Jul 2001 08:31:28 -0800
The other week a new production
-L
it's possible that the index was small enough to stay cached in the SGA?
From: Miller, Jay [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Tuning question - Why did this index help so much?
Date: Wed, 25 Jul 2001 08:31:28 -0800
of list ORACLE-L
it's possible that the index was small enough to stay cached in the SGA?
From: Miller, Jay [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Tuning question - Why did this index help so much?
Date: Wed, 25 Jul 2001
, July 25, 2001 12:57 PM
To: Multiple recipients of list ORACLE-L
it's possible that the index was small enough to stay cached in the SGA?
From: Miller, Jay [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Tuning question - Why did
Miller, Jay wrote:
The other week a new production process was running much more slowly than
anticipated. A file needed to be sent out by 6:00pm and at the rate the
table was being populated it wouldn't complete until around 9:30pm. The
production people and developers came to me for help
