Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-02-19 : 23:53:24
|
Ross King writes "Hello,
Hope somebody can help me?? I'm in my final year at Bournemouth university (England) and have to build a data model and test the three join straegies in Oracle SQL (sort-merge, hash, nested loop)
I have two tables at present and am really struggling as to how I actually run different queries without the optimizer cutting in. Not even sure my coding for running the joins is right.
Could you point me to any info. that would help?? My table consist of 250 records and the other with 10,000 records linked through area_id. (probably no use to you at all).
Any help would be a god-send. Need any other info. on it from me then don't hesitate to ask - I'm in desperate trouble here.....
Ross King
(SQL 8.1.6.0.0) on Windows NT
Thanks" |
|
|
|
|
|
Turning off the optimizer