Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Equivalent selects
Message
 
 
To
17/09/2008 16:25:40
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Vista
Network:
Windows 2008 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01348392
Message ID:
01348541
Views:
16
>>>I am assuming these 2 statements are functionally equivalent. Am I correct?
>>>Thanks
>>>
>>>select * ;
>>>from test_financing ;
>>>inner join tip on test_financing.tip_id = tip.tip_id ;
>>>where between(_year,tipyear,tipyear+4) ;
>>>order by lead, st_name, _year 
>>>
>>>select * ;
>>>from tip ;
>>>inner join test_financing on test_financing.tip_id = tip.tip_id ;
>>>where between(_year,tipyear,tipyear+4) ;
>>>order by lead, st_name, _year 
>>>
>>
>>Yes. You will get the same result from both.
>>But abouth to speed you should check Actual Execution Plan.
>
>What is AEP?

If you have SQL Server and same database, you can run your selects there. The only minor difference would be that you need to use BETWEEN differently, e.g.

select * from ... where _Year BETWEEN @TipYearStart and @TipYearEnd

(better use variables for both instead of in SQL).
If it's not broken, fix it until it is.


My Blog
Previous
Reply
Map
View

Click here to load this message in the networking platform