Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
This is a surprise
Message
From
01/03/2000 21:45:47
 
 
To
01/03/2000 18:14:06
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00338270
Message ID:
00340351
Views:
26
>Now your original slow command was:
>
>SELECT A.* FROM Address A, Cons C ;
>>> WHERE C.CCust = "GREATLA2" ;
>>> AND (C.Addrnum = A.Addrnum OR C.PAddrnum = A.Addrnum)
>>>
>
>You say that C.Addrnum and C.PAddrnum are not indexed in CONS. That being the case, can you also try it reversing them in both sides of the OR... trying
>... AND (A.Addrnum = C.Addrnum OR A.Addrnum = C.PAddrnum) instead?
>

Makes no difference Jim, it's just a simple failure of the optimiser to recogize the potential here.
Previous
Reply
Map
View

Click here to load this message in the networking platform