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