Jay Johengen
Altamahaw-Ossipee, Caroline du Nord, États-Unis
Versions des environnements
>>Well,
>>
>>The initial query is:
>>
>>Select a.field1 As Code, a.Field2 As Desc From TableA a Into Cursor tmpCursor
>>
>>The table has an index on field1 so I added:
>>
>>where a.Field1 = ""
>>
>>It's a cheat I know but the query is optimised and works as long as set exact off.
>>
>>The time jumps from 5 secs to under 2.
>>
>
>Hi Mathias,
>
>That is too cool! I just tested it on my setup and got similar results.
>
>Thanks,
I'm not getting what is happening here. What is the 'where a.Field1 = ""' helping do? What is the test and the comparison?
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