Which 1 do u recommend and why?

Question

3.00/5 (2 votes)

See more:

I think performance wise 2nd is faster

Which 1 do you recommend and why?

SQL

SELECT * FROM CUSTOMER_BAK

SELECT * FROM dbo.CUSTOMER_BAK

Posted 28-Oct-11 2:48am

Rakesh S S

Add a Solution

Comments

[no name] 28-Oct-11 8:51am

I recommend not using txt-speak

CPallini 28-Oct-11 9:03am

I second that.

CPallini 28-Oct-11 9:05am

"Which one do you recommend and why?" is, for the human decoder, performance-wise better.

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

E.F. Nijboer · Answer 1 · 2011-10-28T03:06:00

Why do you think the performance would be different? You would first need to know what dbo means in this context. Have a look here: http://msdn.microsoft.com/en-us/library/aa905208%28v=sql.80%29.aspx[^]

If you care about good coding and also about performance you might take another look at "select *". You should explicitly select the fields you want, something like "select A, B, C from table ...". This way you're sure you get the fields the way you want them (because no assumptions can be made on the defined field order of your table). Also, you get better performance by specifying only the fields needed and therefor don't retrieve data from fields you do not need.

Good luck!

André Kraak · Answer 2 · 2011-10-28T02:57:00

Solution 1

As mentioned here
Worst Practice - Not Qualifying Objects With The Owner[^] when you qualify the object SQL will not have to go looking for the object, so performance wise it will be better to use the qualified name.

Using qualified object will also make 100% clear what your intention is.

Posted 28-Oct-11 2:57am

André Kraak

Comments

Corporal Agarn 28-Oct-11 10:42am

I second that. Here I want people to use the database also but that is for our situation. Speed should not be an issue.

Amir Mahfoozi · Answer 3 · 2011-10-31T00:56:00

Solution 3

Hi Amol,
It is something related to before execution (precompile) matters , and its not related to runtime issues. So both of them are executed with the same performance.

Posted 31-Oct-11 0:56am

Amir Mahfoozi