Okay ... Rule Number 1.
Always convert the data type of the *variable value* to that of table column you are comparing with, and not the other way. The later part causes the problem.
Raj
-------------------------------------------------------------
Rajendra dot Jamadagni at espn dot com
Any views expressed here are strictly personal.
QOTD: Any clod can have facts, having an opinion is an art !!
-----Original Message-----
From: Anubha Jalsingh [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 26, 2003 12:19 AM
To: Multiple recipients of list ORACLE-L
Subject: Query failing in CBO mode
[ --- ]
ORDER_NO column is varchar2 field and it may be containing some non-numeric data, so I understand that Oracle may be doing implicit conversion on order_no. But, then why it is working fine in RULE based. The explain plan is same in both cases and is using FULL Table access. The table has unique index on ORDER no.
Thanks in advance.
Manmohan
*********************************************************************This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*********************************************************************1
