Re: Force implicit data conversion

From: Norman Dunbar <oracle_at_dunbar-it.co.uk>
Date: Mon, 02 Mar 2015 21:08:02 +0000
Message-ID: <6F18F962-B39A-43A9-8FC2-9227122C935B_at_dunbar-it.co.uk>

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.

--

http://www.freelists.org/webpage/oracle-l Received on Mon Mar 02 2015 - 22:08:02 CET

This message: [ Message body ]
Next message: Ls Cheng: "Re: merge waits on library cache lock when reference a table alias"
Previous message: MARK BRINSMEAD: "Re: gcc compiler"
Maybe in reply to: stephen van linge: "Force implicit data conversion"
Next in thread: Kim Berg Hansen: "Re: Force implicit data conversion"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message