I have an SQL 2000 table that has a non clustered Index built. When using Select statements in VB to open this table, do I need to reference the Index that is built or is the Index automatically used? If not, what is the correct syntax for using the Index in my open statement?

Thanks