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 - 2006-10-20 : 07:58:32
|
| Buba writes "I have the following problemI run the query that consists of derived table (subquery) and about 5 tablesIt takes me about 60 sec to get data.But if i exclude derived table it takes only about 5 sec and if i only execute subquery it takes about 4 secWhy do i get such a big difference? + If i put date from subquery into temp table and then join that temp table with my select it takes about 10 sec for everything.So, I'm confused why my query and subquery don't work well together" |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-10-20 : 08:07:15
|
Please post your query here. It's difficult to comment without looking at the query
KH |
 |
|
|
|
|
|
Nested query in select with many joins