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 |
|
thiruna
Starting Member
41 Posts |
 Posted - 2003-05-31 : 02:36:51
|
| Just a quick clarification on views in SQL2000.I have created view which contains 5 tables using SQL designer. When i run that view, all rows from the main table are duplicated in the view result. I am using this view to search text in all fields (from multiple tables) and filtering it with "select distinct blob...blob... From the view".Does this take lot of resources in SQL?(Suppose if my table contains more than 5 tables, after joining other tables with this table, the view contains 30rows of records)Please clarify...thanksthiru |
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2003-05-31 : 09:09:48
|
| Not a lot of resources at all to return, but it can be a lot of data (potentially) to send over a network.SQL returns "square" sets of data in a row/column format, so it repeats "header" rows over and over as you mentioned. But it processes the data very efficiently -- that's what it was designed to do!- Jeff |
 |
|
|
|
|
|
Clarification on view...