>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.