Re: to_char( ) column indexable

From: John P. Higgins <jh33378_at_deere.com>
Date: Mon, 08 Feb 1999 19:07:30 -0600
Message-ID: <36BF8A52.76F01B22@deere.com>

Have you tried:

"select a, b from XYZ where cid = to_number(:d1)"

Steve wrote:

> Hi,
>
> In the query
> "select a, b from XYZ where to_char(cid) = :d1",
> the cid index is not used due to to_char function. Has anyone indexed
> on to_char(column) to do the query, or any other way around?
>
> Thanks.
>
> Steven
Received on Mon Feb 08 1999 - 19:07:30 CST

This message: [ Message body ]
Next message: Gerry West: "script to grant select to V$ tables"
Previous message: Jennifer: "Oracle Database Coordinator"
In reply to: Steve: "to_char( ) column indexable"
Next in thread: Thomas Kyte: "Re: to_char( ) column indexable"

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US