Re: Index Limit

You could also look into the advanced indexing of OMNIDEX, which will give you instant keyword access to your VARCHAR2(4000) field, with superior performance to Intermedia Text. See

http://www.disc.com/keyword.html for details on keyword indexing and
http://www.disc.com/prllnl.html for a customer who chose OMNIDEX over
Intermedia. Or contact me for more information.

Cheryl Grandy
cgrandy_at_disc.com
303 444 4000
DISC Get OMNIDEX for the fastest
applications ever

  In article <xxuD5.21113$O7.309372_at_ozemail.com.au>,   "Robbo7" <robbo7NoSpam_at_ozemail.com.au> wrote:
> Hi Det,
>
> Thanks for the tip I will certainly look into the Intermedia Text
 index.
>
> Robbo7
>
> <moerkd_at_my-deja.com> wrote in message

 news:8rkcqg$lv$1_at_nnrp1.deja.com...
> > Hello,
> >
> > The index length is limited, on Oracle 7 it was about 500 Bytes
 length.
> > So 3218 seems to be a Oracle 8 or 8i. If you use Oracle 8i then
> > you can use a Intermedia Text index. If you use it for fast
 retrieval
> > of the content this would be the right option.
> >
> > HTH
> >
> > Det
> >
> > In article <#5r3XN2LAHA.327_at_net025s>,
> > "Reinier" <Reinier_Dickhout_at_hetnet.nl> wrote:
> > > It may seem silly to you, but I'm wondering why you want to index
 a
> > > Varchar2(4000) field. If it's because you're joining two tables
 and
 this
> > > field is one of the joining columns than I think you have a
 redundancy
> > > problem. I can't think of any other reason to index it.
> > >
> > > But as to your question, I don't think it's possible.
> > >
> > > Reinier.
> > >
> > > Robbo7 <robbo7NoSpam_at_ozemail.com.au> wrote in message
> > > news:ud4D5.19976$O7.285509_at_ozemail.com.au...
> > > > Hi,
> > > >
> > > > I have a column defined as VARCHAR2(4000). When I try to index
 this
 column
> > > > I get a message, "ORA-01450: maximum key length (3218)
 exceeded".
 Is
 there
> > > > a way of changing this so that I can index my text column? It
 would seem
> > > > silly if Oracle allows me a 4000 character column but won't
 allow
 me to
> > > > index it.
> > > >
> > > >
> > >
> > >
> >
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
>
>

--


Sent via Deja.com http://www.deja.com/
Before you buy.