Re: Query directly from secondary index

>> But, it will only go through all the rows of the index, not the 
>> base table.

> I'm certainly no expert on this but wouldn't the file size of .db 
> file have a rather minor impact?

Imagine a 100MB file on network server.  With a 500k index file.

A query draws the entire table local, and THEN processes the query.

Which file would you prefer to bring local for the query to act on?

-- 
------------------------------
 Tony McGuire