>>tables. The queries I submit are usually against 1- to 2-million record
>>tables that are returning anywhere from 10 to a few hundred records in less
>>than 5 seconds.
>
>Did you ever have anyone complaining to this? Shoot him.
>
>>>Queries against large VFP tables are definintely faster with index on
>>DELETED().
>>
>>Do your DB2 tables have an index on DELETED()? Are (Can) DB2 indexes (be)
>>built from within your VFP app? If so can you give me a code snippet that
>>shows how you do it? (i.e. Using the DB2 table exclusive, delete tag all,
>>pack and index on...) Thanx //:^)
>
>Does DB2 here mean the mainframe RDBMS or dBase II type tables? In both
>cases, I'm curious too.
DB2, I believe, is the IBM mid-range/main-frame rdbms that you get on AS-400 and larger machines