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 - 2007-01-08 : 08:02:06
|
Snehalata writes "if i break up the table in two tables(Vertical partitioning) and create a view. if one table is having the most commonly used field and i query from the view then the view would use both the table by join or would fetch data from one table only?" |
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-01-08 : 08:34:01
|
As far as vertical partitioning is concerned, if it can resolve query by looking at just one table, it should hit only one table. But why don't you try it and let us know if you find something strange?Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
|
|
|
|
|