Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Seek index help needed
Hello...
I have a very large table with three fields, SSN(C), enter_date (datetime) and complete (logical). I am wanting to build an index which would provide the fastest performance with the seek command. My goal is to locate any matching social security numbers, with a complete file (.t. in complete) that have already had an application entered within the past 90 days using enter_date. (There could be more than 1.)
Any suggestions?
Thanks very much for your time.
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement