Re: ?iso-8859-1?Q?Indexes with substr?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: 21 Sep 2001 07:20:34 -0700
Message-ID: <a20d28ee.0109210620.470e2d6a@posting.google.com>

"mpinzuti" <mpinzuti_at_virgilio.it> wrote in message news:<3B6A9171000245EB_at_ims2a.cp.tin.it>...
> I'd like to know whether the function SUBSTR() on a field uses the index
> eventually defined on that column.
>
> Thanks in advance

Which version?

In Oracle 7.3 and 8.0 the index will not be used. In Oracle 8i *enterprise edition * you can define a function based index on the substr expression. This won't help you if the substr expression isn't fixed.
Generally speaking of course it is always more easy to concatenate columns than to parse them, if that's what you're up to.

Regards,

Sybrand Bakker, Senior Oracle DBa Received on Fri Sep 21 2001 - 09:20:34 CDT