Re: Compiste keys, large sets, interactive scrolling

From: Jurij Modic <jmodic_at_src.si>
Date: Wed, 27 Jan 1999 20:43:46 GMT
Message-ID: <36af7a4d.7099944@news.arnes.si>

On Wed, 27 Jan 1999 01:28:14 -0500, Bernard Dhooghe <nomen_at_ibm.net> wrote:

> A composite key key_comp is made of number of these columns:
>
> key_comp = (col3,col4,col1,col2,col7)
>
> Suppose the cols are all character, the logical composed key would
>be the
> concatenation of the columns.
> Can Oracle server handle the queries (written in pseudo-sql):
>
> select * from table where key_comp > (?,?,?,?,?)
> or
>....[SNIP]....
You'll have to wait until Oracle8i comes out. It is supposed to have "functional indexes" (i.e. indexes with expressions/functions applied to indexed columns) implemented.

> Bernard Dhooghe

HTH, Jurij Modic <jmodic_at_src.si>
Certified Oracle7 DBA (OCP)

---

The above opinions are mine and do not represent any official standpoints of my employer Received on Wed Jan 27 1999 - 14:43:46 CST