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: Index problem

Re: Index problem

From: D.L. McKinnon <mckinnon_at_ix.netcom.com>
Date: 1997/05/02
Message-ID: <336A60BD.3716@ix.netcom.com>#1/1

Ku Kam Ming wrote:
>
> HI,
>
> I have a table :
>
> title varchar2(500),
> author varchar2(500),
> abstract varchar2(500)
>
> I cannot create index for each column as the maximum allowable length is
> 758. Is this mean I cannot create index on this table? Or any other
> method?
>
> Thanks in advance,
> --
> **********************************************************************
> Kam-ming Ku (kmku) Big-5:[ÅUÀA©ú] GB: ~{9K=uCw~}
> *********************************************************************
>

If I may be so bold, create 3 separate tables w/ a number column in each , write a view with a join, after indexing each table... Received on Fri May 02 1997 - 00:00:00 CDT

Original text of this message

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