Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 Database Design and Application Architecture
 Vertical Partitioning

Author  Topic 

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?"

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 Athalye
Go to Top of Page

- Advertisement -