Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Index problem
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