>I understand that having CDX-tags improves performance of SQL statments in a VFP App. My question is does it also improve performance in the following case: A IIS web site having asp pages with SQL statments pointed at DBF/FPT files sitting in a system DSN 'Free Table Directory' with 'Fetch in Background' off. If the answer is yes, should the tags be on the fields that are used in JOINS, WHERE clauses, ORDER BY, or what???
>
>TIA for any responses to the specific question or to the set up in general.
>
>Paul Emery

Paul;

I do not see any benifit to have a CDX if as an example you are going to use ADO to connect to the data. I could be wrong so let's see what others have to say.

Tom