Re: function based index

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Fri, 13 Dec 2002 19:54:24 +0100
Message-ID: <vvakvucrabi24spgqv6fk4bh3k7ejmpal1@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 Received on Fri Dec 13 2002 - 12:54:24 CST