Re: function based index

From: Paul Brewer <paul_at_paul.brewers.org.uk>
Date: Fri, 13 Dec 2002 21:22:32 -0000
Message-ID: <3dfa51d2$1_2@mk-nntp-1.news.uk.worldonline.com>

"Sybrand Bakker" <gooiditweg_at_sybrandb.demon.nl> wrote in message news:vvakvucrabi24spgqv6fk4bh3k7ejmpal1_at_4ax.com...
> On Fri, 13 Dec 2002 16:41:08 +0100, "Christoph Seidel"
> <chris666.seidel_at_gmx.de> wrote:
>
> >is this possible in 8.1?:
> >
> >
> >create index idx on table(substr(field, 1, 1));
> >
> >and then use the select:
> >
> >select * from table where substr(field, 1, 1) = 'X';
> >
> >
> >
> >
>
>
> Provided you have the Enterprise Edition, yes: this is yet another and
> novel way to get around lousy design.
>
>
> Sybrand Bakker, Senior Oracle DBA
>
> To reply remove -verwijderdit from my e-mail address

Sybrand,

Do you really think that these guys are going to understand that they need to decompose their attributes?

Regards,
Paul Received on Fri Dec 13 2002 - 15:22:32 CST