Don't Use SELECT *

Why not join our community?, there are 13 users online

home
tips & tricks
view story

DotNetKick.com is an open-source project. Please report any bugs and let us know your great suggestions. Currently running svn revision 620 (rss)

Kick Spy!, Kick Zeitgeist and Kick Widgets

16
kicks

kick it

Don't Use SELECT *

published 3 months, 4 days ago, submitted by misbaharefin 3 months, 5 days ago

dotnethitman.spaces.live.com — I've seen many developers actually using and abusing SELECT * FROM queries. SELECT * query not only returns unnecessary data, but it also can force clustered index scans for query plans because columns in the SELECT clause are also considered by the optimizer when it identifies indexes for execution plans.

1 comment | category:

Tips & Tricks | Views: 361 | Get KickIt image code

tags: Tips | tag it

Everyones tags:

Your tags:

Please login or signup.

Add a live kick counter to your blog >> liveImage

You can even customize the image by choosing your own colors, and then clicking the button below to update the preview and the html code:

"Kick It" text
"Kick It" background
kick count text
kick count background
border

Simply copy and paste this HTML into your blog post.

Users who kicked this story:

misbaharefin -

adminjew -

StefanPienaar - bags -

jonas - locrain - rmorlok - schwankie - fintz69 -

gt1329a - mghaoui -

mdopp -

prashantvictory - marlongrech - Amaranth - hwaheed

Comments:

as good as this advice is the first execution plan has nothing to do with the * itself.
It is showing a bookmark lookup that will happen for every query when you're filtering on a column that has a non clustered index and
columns in the select list that are not covered by a non clustered index.
because data is stored in the leaf level of the CI a bookmark look up is looking up that data in the CI.

just to clear thing up :))

other than that the advice is sound!

posted by spirit1 3 months, 4 days ago