Re: Force implicit data conversion
- From: Norman Dunbar <oracle@xxxxxxxxxxxxxxx>
- To: kibeha@xxxxxxxxx,dmarc-noreply@xxxxxxxxxxxxx
- Date: Mon, 02 Mar 2015 21:08:02 +0000
Interesting discussion.
On my Oracle Performance Tuning course, some time back, we were told that the
column data type was always converted to the data type it was being compared
with, whether it was on the left or right side of the comparison operator.
Hence the inability to use existing non-function based indexes.
Cheers,
Norm.
--
Sent from my Android device with K-9 Mail. Please excuse my brevity.
Other related posts:
