>Thanks all for the responses.
>
>I guess it is possible that 100+ tags COULD slow an SQL down, but to me it seems it would only be for a fraction of a second more as SQL initially checks tags based on where clause to see if indexes exist. I'm not sure about this but it seems logical that VFP would only do this ONCE before the SQL actually starts.

Yes, I'm only talking a slight pause, I've observed it with 30 or 40 tags on LOCATEs, for example, and only once per tag. I'll bet you could create an artificial example with 1000s of tags that could get slow, if you really wanted to test it :)

Also, you could get memory bog if the CDX is very large. This actually could've been the case where I've seen the pause, now that I think about it - these were very large tables and CDXs...

What will really slow SQL down is what Rudy was referring to over something like RAS. When a large chunk of an index is brought over a slow wire, that's when you can really experience delay before even considering record transfer.