Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
>Are we talking a different network server? Could you be seeing a difference in network response time? Did you add any indices to the .cdx on your personal copy?
>
Thanks for your reply. No on both accounts, it's all on one NT server...there is an addition though...I was checking it out, and while everything is still slower, I noticed that a SELECT on a description doesn't take near as long as a SELECT on a part number...it turns out that there are 2 indexes in the main database for the part number, one is descending, based on part number alone, the other is ascending based on UPPER(partno). Could that compound the difference? Is there a way I can make sure that my SELECT statement will use the ascending index? Is this a valid concern? ...the quest continues;)
Précédent
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