May 23, 2002 at 9:36 am
Okay, If I do a select * from table1 where <conditions> the query is speedy and making me happy.. But, If I do a select column1 from table1 where <conditions> the query is slow and making me sad.
Why does the optimizer change the query plan and make things worse when I pick a specific column instead of all of them????? Dumb optimizer 🙂
"Keep Your Stick On the Ice" ..Red Green
May 23, 2002 at 10:53 am
That is odd as it is generally faster to get a single column as the resultset as oppossed to all. Run
SET SHOWPLAN_TEXT ON
GO
QUERY1
GO
QUERY2
GO
SET SHOWPLAN_TEXT OFF
GO
and post the output here. I would be curious as to what all is changing.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply