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 |
|
Vinnie881
Master Smack Fu Yak Hacker
1231 Posts |
 Posted - 2010-05-07 : 14:48:48
|
This makes no sense to me.I have a query that when I doSelect * fromtbl1 ainner join...(About 10 table joins)it runs in 0 seconds (Very good performance)but when I doselect a.col1,b.col2,c.col2...from Myqueryit takes 45 seconds???The select list is doing nothing besides displaying the same selected columns as when I do "Select *"...Any ideas on why a select list that has NO formula's or subqueries would effect the execution plan?Thanks!
Success is 10% Intelligence, 70% Determination, and 22% Stupidity.\_/ _/ _/\_/ _/\_/ _/ _/- 881 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-05-08 : 04:18:26
|
| Look at the query plan for both and see if/where they are different? |
 |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
|
|
|
|
|
Huh?? 0 seconds vs 45 seconds??