Index on a field

[BittenApple]

Hello team,
I have a query in sql server, I only have read/ select right to database. I wonder if I can insert an index on one the fields that I am going to use in a query.
Or should I create a view and then insert an index on that field in a view?
Regards,
appbita

[HansV]

If you have read-only permissions, I assume that you cannot create indexes or permanent views...

[BittenApple]

Hello Hans,
Then what approach should I take to load data and insert the index on a field that I want?
Regards,
appbita

[HansV]

You could open an ADO recordset on a table and set an index on the recordset. See Seek Method and Index Property Example (VB). The example uses an Access database, but it should work for a SQL Server database as well.