Mike:
According to the docs, the first time an query is parsed, Oracle peaks at
the bind variable and bases the explain plan on those values. The values of
the bind variables are never looked at again
Kevin
-Original Message-
Sent: Tuesday, July 23, 2002 6:58 AM
To: Multiple recipients
to include binds.
Good luck.
Barb
--
From: oraora oraora[SMTP:[EMAIL PROTECTED]]
Reply To: oraora oraora
Sent: Sunday, July 21, 2002 8:24 PM
To: [EMAIL PROTECTED]
Subject: Re: bind vars change explain plan
Baker,
sorry i did not read the reply
--
From: oraora oraora[SMTP:[EMAIL PROTECTED]]
Reply To: oraora oraora
Sent: Sunday, July 21, 2002 8:24 PM
To: [EMAIL PROTECTED]
Subject: Re: bind vars change explain plan
Baker,
sorry i did not read the reply to ur query.
what was the reply
highly recommend you
continue
with your code changes to include binds.
Good luck.
Barb
--
From: oraora oraora[SMTP:[EMAIL PROTECTED]]
Reply To: oraora oraora
Sent: Sunday, July 21, 2002 8:24 PM
To: [EMAIL PROTECTED]
Subject:Re: bind vars change