RE: question on EXPLAIN_PLAN

2002-02-07 Thread
: 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

RE: question on EXPLAIN_PLAN

2002-02-07 Thread Nicoll, Iain (Calanais)
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

RE: question on EXPLAIN_PLAN

2002-02-07 Thread Seefelt, Beth
: 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

Re: question on EXPLAIN_PLAN

2002-02-07 Thread kevin wang
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

Re: question on EXPLAIN_PLAN

2002-02-07 Thread Jared Still
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

Re: question on EXPLAIN_PLAN

2002-02-07 Thread Mohammad Rafiq
. ~ 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

question on EXPLAIN_PLAN

2002-02-06 Thread kevin wang
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

Re: question on EXPLAIN_PLAN

2002-02-06 Thread Mike Killough
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

Re: question on EXPLAIN_PLAN

2002-02-06 Thread kevin wang
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

Re: question on EXPLAIN_PLAN

2002-02-06 Thread kevin wang
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

Re: question on EXPLAIN_PLAN

2002-02-06 Thread Mohammad Rafiq
. 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