Jay Johengen
Altamahaw-Ossipee, North Carolina, United States
>>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?
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only