Which one is faster for performance view or form joining tables ?

Question

0.00/5 (No votes)

See more:

SQL

database

SQL-Server-2008R2

I have a store procedure in which i used view for getting data. so it is good or can i user tables instead of view

Posted 15-Oct-14 20:15pm

Dj@y

Add a Solution

Comments

NowYouSeeMe 16-Oct-14 2:24am

it depends..if you have a table with 200 columns and you need only 10 columns then using view is the faster-better approach

Dj@y 16-Oct-14 5:10am

i am getting data from 8 tables in view. and use that view in sp and all tables have more than 10 columns. so can I use the view or 8 tables. which one is better for me

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)

Santhosh Babu Mahimairaj · Answer 1 · 2014-10-15T21:08:00

Solution 3

whether you use a select statment or a veiw you will be pulling data off the drives (or cache) to produce the answer. The view has the advantage of being pre-optimized. Views are generally used for this type of thing as it hides all the aggregation.

Posted 15-Oct-14 21:08pm

Santhosh Babu Mahimairaj

Comments

Bernhard Hiller 16-Oct-14 4:54am

Let me add that Microsoft SQL server has many built-in optimizations: having executed a query once, some steps stay cached, e.g. the execution plan. That means, when calling it the second time, the performance will be better than at first time, and differences to pre-optimized views disappear.

Magic Wonder · Answer 2 · 2014-10-15T20:23:00

Solution 1

Hi,

Check this

What is the difference between view and tables in sql[^]

Hope this will help you.

Cheers

Posted 15-Oct-14 20:23pm

Magic Wonder

King Fisher · Answer 3 · 2014-10-15T20:30:00

Solution 2

Indexed Views :

http://technet.microsoft.com/en-us/library/dd171921%28v=sql.100%29.aspx[^]

This may help you :)

Posted 15-Oct-14 20:30pm

King Fisher