Oracle FAQ

Your Portal to the Oracle Knowledge Grid

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

Home -> Community -> Usenet -> c.d.o.server -> Re: SQL: want to create index based on part of column value

Re: SQL: want to create index based on part of column value

From: Roman Starek <starek_at_pluto.spsselib.hiedu.cz>
Date: 2 Jun 1999 10:13:17 GMT
Message-ID: <7j303t$pnc$1@adis.cesnet.cz>

Simply use column with value derived from your column and then create index on derived column Values in derived column should be maintained through insert and update trigger.

Starous Received on Wed Jun 02 1999 - 05:13:17 CDT

This message: [ Message body ]
Next message: Gennady Zaraysky: "Re: CASE for Oracle8i"
Previous message: Reiner Neumann: "looking for Oracle-Y2K-Newsgroup"
Maybe in reply to: Jean-Pierre Dery: "SQL: want to create index based on part of column value"

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