Thanks for the response Sergey.

Let me put it this way, if I do sql passthru let's say from foxpro to SQL Server as example "select * from customer where ncust_id = 3" then only one record goes over the wire,but if the database is foxpro and there's 1 index on ncust_id and I have the same query, what would be transferred over the wire apart from the one record?