Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
What's the main difference?
Message
 
To
30/01/1997 13:16:36
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00018843
Message ID:
00018846
Views:
31
>What's the main difference of those 2 SQLs? Am I right to say that the first one is faster than the second one?
>
>SELECT ELEM_ID FROM ELEM WHERE EXISTS (SELECT ELEM_ID FROM ANSWER WHERE RATER_ID=254 AND ANSWER.ELEM_ID=ELEM.ELEM_ID)
>
>SELECT ELEM.ELEM_ID FROM ELEM,ANSWER WHERE ANSWER.RATER_ID=254 AND ANSWER.ELEM_ID=ELEM.ELEM_ID AND ELEM.CHILDREN

where is the elem.children in the first sql?

in theory (according to the books) the first one should be faster...
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform