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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-05-18 : 08:59:42
|
| Yogesh writes "Suppose I have two tables named a and b,the size are a= 1mb and b=5 mb.I am creating a view which contains data from both table,then what will be the size of view ?" |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-05-18 : 09:16:06
|
| 1 + 5 = 6?hope i get the math right...--------------------keeping it simple... |
 |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-05-18 : 09:16:37
|
View is not phyical table but just a stored query
KH |
|
|
|
mahimam_2004
Starting Member
40 Posts |
Posted - 2006-05-19 : 01:55:54
|
| Hi,The view size is 0 |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2006-05-19 : 02:09:51
|
| The view might be indexed, of course. |
|
|
|
|
|
|
View Size