Indexes on raw tables?

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

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

This feature was first introduced in XPS and then moved over to IDS in 10.00.UC1. John Miller 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 >