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 |
|
caralvi
Starting Member
2 Posts |
 Posted - 2003-06-10 : 20:44:26
|
| When I submit a query with a join clause and one of tables doesn´t have any index clustered, a Execution Plan show me that will have a Table Scan and how I have a server with 4 processors will have a parallelism step. However SQL doesn´t respect one of where clause and the result set is different that when I create a index clustered in any column of that table.Anyone can help me? |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2003-06-10 : 23:05:20
|
| I'm not sure what you are getting at. Can you post the query(ies), a subset of the results, and how they differ?-Chadhttp://www.clrsoft.comSoftware built for the Common Language Runtime. |
 |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2003-06-11 : 10:41:15
|
| >> However SQL doesn´t respect one of where clause Would like to see that. Does it appear in the query plan?>> the result set is different that when I create a index clustered in any column of that table.It will be ordered differently but should be the same unless you are limitting data in the query without an order by.There have been a lot of bugs due to parallelism - what happens if you set maxdop?==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
caralvi
Starting Member
2 Posts |
Posted - 2003-06-11 : 10:50:42
|
| Chad,In this case, the result set doesn´t respect one clause where that explict "is null" so the result set contain some record "not null".nr,In query plan doesn´t appear this clause above. |
|
|
|
|
|
|
Parallelism