ABF index for compiles

Subject: Re: Speed up ABF compile

> Sometime ago, I built an extra index on one system catalog table, the index
> sped up building application images in Ingres 6.4/06, HP-UNIX. But now I can
> not remember how to create the index. Hope someone can refresh my memory.
> 
> Thanks
> George Wang

Hi George,

    Update the file $II_SYSTEM/ingres/files/dictfiles/cor02min.mfy.

    Include the lines:
    CREATE INDEX ii_object_name_index ON ii_objects
        (object_name,object_class,object_owner,object_id)
        with key=(object_name,object_class), structure=btree

    Martin Bowes

Ingres Q & A

Back to William's Home Page

Email William