If you are on version G1.05 of Image/SQL, you need to perform an update
statistics if you are using Third Party Indexing (TPI) and your indexes
are not showing up in the SYSTEM.TPINDEX table.  Make sure that your TPI
product is current and registers the indexes in SYSTEM.TPINDEX.  SUPERDEX
does not perform the register before version 4.1.
 
If you are using an older version of Image/SQL, you probably have to.
 Some older versions  do not utilize the Image Keys.
 
Hope this helps.
 
John Spivey
Litespec Optical Fiber, LLC
Research Triangle Park, NC
<[log in to unmask]>
 
 ----------
From:  Larry[SMTP:[log in to unmask]]
Sent:  Thursday, May 16, 1996 3:53 AM
To:  Multiple recipients of list HP3000-L
Subject:  Update Statistics Allbase
 
Howdee All,
        I have a large attached data base - 250app datasets ---- ur that
is
tables.  For Allbase's Sql engine, do I need to update statistics for
all the datasets????
 
        Pure lazy or tring to work smarter not harder.   Larry