Although this may seem obvious to some, I have yet to become a novice on
ODBC/ISQL/SQL and access to IMAGE DB's using SQL.  My question is this:  I
have a Manual Master dataset with DBE attached.  I wish to produce a query
for a subset of the manual master.  For this examples sake:

Employees is my Manual master.  SS# is the key.  The DB is enabled for
IMAGE/SQL and the query is working (although slowly).

In an effort to improve access speed online, I want to do an SQL through
ODBC that doesn't read all records in the IMAGE DB serially.  For example,
all last names starting with 'MA'.  In IMAGE, this would require a serial
read.

Having said that...On the HP3000 (all on the 3000) I could accomplish this
through a 3rd party indexing product such as Superdex or Omnidex and build
my key as I see fit.  My programming would take care of the rest of the
details.  I've done this before and response times are good.

With ODBC using an SQL statement, I am afraid that I might not be able to do
this in an efficient manner.  Testing this method seems to read all records
serially.  Do I need to read the Allbase/SQL(Create Index) manual or where
would I go to research how to get to my desired result.  If I were to create
an index using ISQL, is this index maintained in the DBE only?  Any broad
direction on where to look for research material would help.  Thanks in
advance.

Todd Matteson
Business Application Manager
Huffy Service First
8521 Gander Creek Drive
Miamisburg, OH 45342
E-Mail:[log in to unmask]
Phone:(937) 436-5141