You have to create the indexes on the SQL Tables. You can do that from within VFP by using the alter table command in your sql statement and passing it to SQL.



>Thanks John but from withing the VFP environment, how to get indexed data of SQL server. Is there any example available to access and update the SQL server data
>
>Thanks