VB ADO Index by Date

Is it possible to index a database with a date field?  I have a database that has 2 million records and would like to search records by the transaction date.  Using the ADO seek will work but takes a long time.  Not sure how to do about this, if it possible at all.  I am using VB 6.0 with ADO.  The database is an Advantage Database.  I can also use SQL too, I guess.  Any thoughts or comments would be appreciated.
grandrewAsked:
Who is Participating?
 
aikimarkConnect With a Mentor Commented:
Open the database with the Advantage database console, select the table, click Add Index and select the date field.

Note, that date fields may include a time-of-day component and might not give you the results you want if you expect day granularity.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.