SQL Indexes

[William Reyes]

I have a question regarding indexes.

This may be a SQL newsgroup question. If it is I apologize. I actually
posted it on both just in case.

If I create an index on a table. Will this index be checked through when I
execute a select statement from VB.NET or is this index only used through
strored procs within sql.

 

[Joe Fallon]

Any SQL Statement will cause the server to generate a query plan.
If the query plan decides to use an index, it will.