Unix Technical Forum

RE: Indexes on raw tables?

This is a discussion on RE: Indexes on raw tables? within the Informix forums, part of the Database Server Software category; --> Must have missed that bit. Thanks. DC > -----Original Message----- > From: informix-list-bounces@iiug.org [mailto:informix-list- > bounces@iiug.org ] On Behalf ...


Go Back   Unix Technical Forum > Database Server Software > Informix

Register FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 04-20-2008, 11:17 AM
Doug Conrey
 
Posts: n/a
Default RE: Indexes on raw tables?

Must have missed that bit. Thanks.

DC

> -----Original Message-----
> From: informix-list-bounces@iiug.org [mailto:informix-list-
> bounces@iiug.org] On Behalf Of Roy Mercer
> Sent: Thursday, June 01, 2006 9:32 AM
> To: informix-list@iiug.org
> Subject: Re: Indexes on raw tables?
>
> They just have not documented the feature yet.
>
> This works as long as the index is not for RI. (Primary key or Foreign
> key).
>
> I think it is documented in 10.XC5 and 9.40.XC8
>
> This was mentioned at the user conference in Tampa.
>
> FYI
>
> Doug Conrey wrote:
> > I'm running IDS 10.0.FC4 on AIX 5.3 and I just noticed that I can

create
> > an index on a raw table, or convert a standard table to raw with

indices
> > still on it (where before I would get "This operation is not allowed

on
> > a table where the type is raw."). The engine still uses the index,

and I
> > can't find any errors. The documentation still says that indices are

not
> > allowed on raw tables. Has this changed? Is this a bug? Thanks.
> >
> >
> >
> > DC

>
> _______________________________________________
> Informix-list mailing list
> Informix-list@iiug.org
> http://www.iiug.org/mailman/listinfo/informix-list

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 10:25 PM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com