Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
scelamko
Constraint Violating Yak Guru
309 Posts |
Posted - 2007-03-08 : 09:52:53
|
Guys,I have a select query which joins mutilple tables, each time when I try search for a record the select query is executed.Is it advantageous to build a view on top of the select query and do a simple select from the view.All I can think of is the view is going to save the sql parsing time. Am I right ? any suggestions/inputs on select from multiple tables Vs view would help.Thanks |
|
Kristen
Test
22859 Posts |
Posted - 2007-03-08 : 10:05:57
|
"is the view is going to save the sql parsing time?"I don't think so - but someone more knowledgeable than me may have a concrete answer.If you say:SELECT Col1, Col2 FROM MyView WHERE Col3 = '123'then I doubt that the query plan is going to be reused forSELECT Col1, Col2 FROM MyView WHERE Col3 = '456'however, if you use a stored procedure, or a parameterized query, along the lines of:SELECT Col1, Col2 FROM MyView WHERE Col3 = @MyParameterthen there is a good chance that it will be cached (and in this regard it doesn;t make any difference wither you are querying MyView or MyTable1 JOIN MyTable2 ... etc)Kristen |
|
|
rlaubert
Yak Posting Veteran
96 Posts |
Posted - 2007-03-08 : 10:30:21
|
A view per say will not reduce the processing time as it must be optimized just like an adhoc query. However, a view does reduce the complexity of the query for the user and because views have a tendency to be used more that adhoc querys the execution plan may already be cached which would reduce processing time.To get the best performance from a view make sure you have the proper indexes for the joins and the where clauses. That way the optimizer will have the best chance of reducing the execution time and cost.Raymond LaubertMCDBA, MCITP:Administration, MCT |
|
|
scelamko
Constraint Violating Yak Guru
309 Posts |
Posted - 2007-03-08 : 11:06:55
|
point taken |
|
|
|
|
|