Re: Querying a number column.

On Fri, 24 Jan 2003 00:56:13 -0500, "Anurag Varma" <avdbi_at_hotmail.com> wrote:

>why would the index be ignored?
>I don't think so. Though I agree about the type conversion.

BECAUSE of the type conversion.
The query is silently transformed into
to_char(column) = '<hardcoded numeric literal>'

left hand side of a where clause function: NO index.

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Fri Jan 24 2003 - 00:41:10 CST