My company is starting to use SQL server and i am going to be hitting it with Foxpro 6 when i designed my views i noticed it didnt really let you do anything in your code untill it had gone to the bottom of the file retrieving all the records i am curious is there a way to speed this up so that when i hit it with a sql statement the speed is quite nice all my indexes are set up fine on the server so i know thats not an issue but i will be working with close to 11 million rows and speed is of the essence any recomendations would be greatly appreciated
Thanks
James