: Wed, February 06, 2002 11:46 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: question on EXPLAIN_PLAN
Hi, Bill
You are right, there is really something to do with the index.
I dropre-created that PK index, it became much faster, but after 5
minutes, it became slow again
PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: question on EXPLAIN_PLAN
Date: Wed, 06 Feb 2002 11:43:38 -0800
Hi, guys
The problem belows is really make me confused and gave me big trouble,
is there someone can give me some hlep
: kevin wang [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: question on EXPLAIN_PLAN
Date: Wed, 06 Feb 2002 11:43:38 -0800
Hi, guys
The problem belows is really make me confused and gave me big
trouble, is there someone
box.
And the table and index is analyzed at same way.
thanks a lot for your reply.
Kevin Wang
- Original Message -
From: Bill Zakrzewski
To: kevin wang
Sent: Wednesday, February 06, 2002 12:38 PM
Subject: Re: question on EXPLAIN_PLAN
Kevin
at same way.
thanks a lot for your reply.
Kevin Wang
- Original Message -
From: Bill Zakrzewski
To: kevin wang
Sent: Wednesday, February 06, 2002 12:38 PM
Subject: Re: question on EXPLAIN_PLAN
Kevin,
Have these indexes been
.
~
Bill Zakrzewski
Senior Consultant
Intactus Technology, Inc.
- Original Message -
From: kevin wang
To: LazyDBA.com Discussion
Sent: Wednesday, February 06, 2002 2:43 PM
Subject: question on EXPLAIN_PLAN
Hi, guys
The problem belows is really make me
confused and gave me big trouble, is there someone can give me some
hlep?
I have two databses, same version(oracle
8.1.6),same O/S(win2000), sameschema structure, different data(but small
difference ofsize).
and even exactly same
Kevin,
Have you analyzed the tables on both databases? Card is the CBO's estimate
of the number of rows it will process.
Mike
From: kevin wang [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: question on EXPLAIN_PLAN
Date: Wed
Zakrzewski
To: kevin wang
Sent: Wednesday, February 06, 2002 12:38
PM
Subject: Re: question on
EXPLAIN_PLAN
Kevin,
Have these indexes been
rebuilt recently? If not, you may want to consider rebuilding the
indexes. Not sure if this is your issue, but if you have
is the CBO's estimate
of the number of rows it will process.
Mike
From: kevin wang [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: question on EXPLAIN_PLAN
Date: Wed, 06 Feb 2002 11:43:38 -0800
Hi, guys
.
And the table and index is analyzed at same way.
thanks a lot for your reply.
Kevin Wang
- Original Message -
From: Bill Zakrzewski
To: kevin wang
Sent: Wednesday, February 06, 2002 12:38 PM
Subject: Re: question on EXPLAIN_PLAN
Kevin,
Have these indexes been
11 matches
Mail list logo