John Express-3 makes a dramatic improvement in the usability of IMAGE/SQL. Prior releases did not register the keys with the Allbase Optimizer so serial reads were always performed. I get < 5 sec responses on datasets much larger then yours. Gary L. Biggs At 10:12 AM 3/4/96 -0500, you wrote: >Greetings: > >I have executed the following query in isql and MS Access. The field >QSQMS.QC_CURR_DTL.QC_TU_KEY is the primary path to the dataset. > OBSERV_ID is not a key. It appears that Image/SQL performed a serial >read on the dataset to obtain the results of this select. I think >Image/SQL should have used the path to retrieve these 5 records, but it >did not. This select takes approximately 65 seconds to execute on a >dataset with ~175k entries. Any opinions out there? .... > >Is there anyone who has installed the Express 3 patch? If so, did it >improve your access to Image keys? Would Express 3 have resulted in >Image/SQL utilizing the path for the above query? > >John Spivey >Sumitomo Electric ><[log in to unmask]> >