How to set SQL Index in a Foxpro View 1

[ntm0n]

I have tables on an MS SQL server and have created multiple index's on those tables. Now - how do I specify which index on the sql server I want the foxpro view to use?

Thanks!

Gary

 

[Guest_imported]

You don't. Things are done differently in SQL Server. All access is via SQL statements. SQL Server will determine which index to use.

Craig

 

[ntm0n]

Hi Craig,

So if I create different index's say one is on a usernumber and another is on lastname, and I submit a view that does a select based on usernumber - the SQL server (MS) will automatically choose the correct index?

 

[fluteplr]

Yes.

Hi Craig, haven't seen you on this forum before.
and you probably don't recongnize my handle.

fluteplr = Jacob B.