> We are about to embark on a comparison between 6.4 and Openingres 1.1.
> Whenever i spoke to anyone about modifying tables etc i told them of this
> GREAT feature in openingres that you can still read the table while it is
> being modified. Another thing was the ability to build secondary indexes in
> parallel (ie, an asynchronous indexing) also while the users have
> read-only access to the base table.
> 
> BUT! Now i cant find it in the documentation anywhere... (i cant remember the
> exact syntax. My memory seems to recall that you could say
> modify XXX to readonly
> And then you could do
> create index YYY on XXX with nowait
> (or something like that)
> )

I have used it on OpenIngres 1.2 on a solaris 2.4 and you are real close.

You first do:

modify tablename to readonly

and then you do all the create indexes (for that table) you want at the same time
after all your create indexes have completed you need to do:

modify tablename to noreadonly

so updates can happen to the table after that.

It works just fine.  Have fun.

Ingres Q & A

To William's Home Page

© William Yuan 2000

Email William