sql server programming: View or Base Table? Which one is faster? -- sql server programming

RE: View or Base Table? Which one is faster?

Omnibuzz
5/11/2006 11:00:01 PM

base_table is faster
unless you views definition is

select col1..... coln
from base_table

[quoted text, click to view]

Re: View or Base Table? Which one is faster?

David Portas
5/11/2006 11:10:13 PM

[quoted text, click to view]

It depends on the query, the view, the indexes, etc. The only way to be
sure is to test it out.

--
David Portas, SQL Server MVP

Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.

SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--

Re: View or Base Table? Which one is faster?

Jim Underwood
5/12/2006 12:00:00 AM

IF your view pulls data from 5 tables, and you only need data from one
table, then you should access that table directly (or access a view that
references only that table, which is the same thing).

Assuming you have proper indexes, this should be faster every time.

This assumes you will not be using data from those other tables at all.

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server programming group.